PC Data Backups

Backup SQL Instructions

1) Backup Database...

1. You can schedule Microsoft Sequel Server to generate backup files on a recurring basis, then select that directory to backup with PC Data Backups.
2. To do so, log into your SQL database, right click the database and select "All Tasks / Backup Database".

2) SQL Server Backup (databasename)

1. By default, SQL selects "Database - Complete". If you wish you can select "Database - Differential".
2. The default destination to save your SQL backup file is typically "C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP". Double click the path to edit it.

3) Select Backup Destination

1. Add "sqlbackup.bak" to the existing path, then click Ok.

4) SQL Server Backup (general tab)

1. Schedule backups by checking the "Schedule" option, then clicking the "..." button.

5) Edit Schedule

1. Select the Recurring radio option, then click the "Change" button.

6) Edit Recurring Job Schedule

1. Select Daily, Weekly or Monthly.
2. Enter a time, preferably at least an hour after your work day ends and an hour before PC Data Backups is scheduled to start.
3. To close out, click "Ok" on each of the two open dialog boxes.

7) SQL Server Backup - Options Tab

1. After the scheduled backup time, check the "C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP" directory to confirm successful backup.

8) RDB Backup View

1. Don't forget to select the SQL backup directory in PC Data Backups.
2. Open the RDB program, click the Backup tab, click "Explore to pick files", navigate to "C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP", and in the right window, check the box to the left of the "sqlbackup.bak" file.
3. The box should now have a green checkmark in it.