CyberSecure™ Microsoft SQL ® Server Online Backup Tutorial

Requirements

• CyberSecure online backup advanced must be installed on the machine running SQL server
• There must be sufficient storage space on the machine to house the entire SQL server data whilst the database is being backed up

Overview

CyberSecure Advanced will backup your Microsoft SQL Server databases by taking the following steps:

1. Before running any backup functions, CyberSecure Online Backup Advanced will first run all pre-commands of the backup set.
2. For each database that is to be backed up, CyberSecure Online Backup Advanced will issue a database/transaction log backup command to Microsoft SQL Server to backup each database to a MS-SQL database backup file (*.bak file) and will save it in the temporary directory specified in the backup set configuration.
3. After all *.bak files have been spooled to the temporary location, CyberSecure Online Backup Advanced will run any post-commands of the backup set.
4. All files in the temporary directory will be encrypted and uploaded to CyberSecure's offsite storage servers.
5. The temporary files will be removed from the temporary directory.

Process for backing up Microsoft SQL Server

IMPORTANT: The recommended backup strategy is to have a weekly database backup and a daily transaction log backup. This means having the MS-SQL database using the FULL recovery model, so that it generates transaction logs.

To check or change the recovery model of your database

1. Open the SQL Management Studio

   

   If SQL server management studio is not available and you are running SQL server 2005 express, please download the SQL express management studio.

2. Login to the MS-SQL management studio

   

3. For each database in the backup, expand out the [Databases] tree and open the properties of each database by right-clicking and choosing [Properties].

   Selecting the [Options] page will display the recovery model, allowing you to change to the FULL recovery model.

   

4. Click OK and exit out of SQL management studio

To setup a Microsoft SQL Server backup set

1. Open CyberSecure Online Backup Advanced
2. In the main screen, click the cog icon:

   

3. Click the plus to add a new backup set, the following dialog box will open:

   

4. Choose your SQL server, SQL login ID and password

   

5. Simply check/uncheck the desired databases for offsite backup

   

6. Choose your desired schedule.

   IMPORTANT: The default schedule of a weekly database and a daily transaction log backup is recommended. This will give the best performance and recovery options.

   

7. Selecting the particular schedule and choosing properties will allow you to see the schedule in more detail:

   

8. Once you are satisfied with your schedule, proceed to the next step
9. Leaving the encryption settings on their defaults is recommended unless you have good reason for otherwise doing so

   

10. That's it, you have successfully setup a MS-SQL backup

    

11. Next steps: either perform a hard-drive seed with your data on it, or immediately backup to CyberSecure offsite storage servers by clicking "Backup" in the main screen.