Scheduled Automatic SQL Database Backup using SSMS and Using Stored Procedure

There are two ways to schedule the DB backup in SQL for SAP Business One DB. 

Option 1 : Using Store Procedure - Follow the Below Steps

1: Create a Store procedure in master DB. - Check Link for Query

2: Run the Query in master

3: Open Object Explorer > SQL Server Agent > Jobs > Right Click (New Job)..

4: Left side > General > 

  > Set Name " Auto Backup"

  > Set Owner "sa" 

  > OK

5: Left Side Steps 

  >  New

  >  Sub Window > set StepName