1. Download the SQL file provided under attachment(s).

2. Open Microsoft SQL Server Management Studio and connect to the Server.

3. Under Databases, go to the company database, right click and select "New Query".

4. Copy the content of the SQL file into the query.

5. Proceed with the steps provided in the script.

1. 1. Defines the location where the database backup would be created and stored.
      
   2. Enter the name of the Database that you would like to backup.
      
   3. As the Backup will be encrypted, define the Password that will be used to extract the backup.
      
   4. Enter the path where the 7Zip program is installed.
      

5. Ensure that the database that you would like to run the backup script on is selected (a) and proceed to Click on the Execute button (b).

This will create the Table, iWoWDB_Backup_Full, under  Databases > 'Company Database' > Programmability > Stored Procedures.

Step 2 - Enable SQL Server Agent

1. Right Click the SQL Server Agent and select Start.

Step 3 - Create New Job

1. Under SQL Server Agent, right click Jobs and select New Job...

2. Configure the New Job according to the Figure shown below. (Note: For Database, Select the database that you are planing to backup)

3. Click on OK

Step 5 - Create New Job Schedule

1. Under SQL Server Agent, go to Jobs and select the Job you had previously created (Eg: BackupDatabase).

2. Click on Schedules.

3. Click on the 'New' button.

4. Configure the schedule for when the backup will occure.Kindly refer to the Figure shown below 

​

2. Click on OK