| |
How do I back up Microsoft SQL Server?
You can schedule Microsoft Sequel Server to generate backup files on a recurring basis, then select that directory to backup with
PC Data Backups. To do so:
- Log into your SQL database, right click and select "All Tasks / Backup Database".
- By default, SQL selects "Database - Complete". If you wish you can select "Database - Differential".
- The default destination to save your SQL backup file is typically "C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP". Double click the path, add "sqlbackup.bak" to the existing path, and click Ok.
- Schedule backups by checking the "Schedule" option, then clicking the "..." button. Select the Recurring radio option, then click the "Change" button. Then select Daily, Weekly or Monthly and the time. To close out, click "Ok" on each of the open dialog boxes.
- After the scheduled backup time, check the "C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP" directory to confirm successful backup.
- Don't forget to select the SQL backup directory in PC Data Backups. 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 folder.
For more information, please see our step-by-step SQL Backup instructions or
visit the Microsoft SQL
Server TechCenter.
|
|
|
~ 
