Installation > Setting up a Backup Procedure > Setting up a Backup Procedure
Setting up a Backup Procedure
This topic contains the following sections:
Backing up a running database
Backing up a model
The following table outlines the steps to be taken to set up a back up procedure for database information.
Step
Consideration
1. Talk to the network administrator responsible for file backups.
You need to determine the following from the network administrator:
At what time the backups are created.
Disk locations that are backed up. During installation, you can specify a folder for backups. By default, this folder is on the same disk, but you should consider saving backups to a different disk. You can override the default backup location when back up procedure is performed.
2. Set up a batch file or use SQL Server to automatically back up your database.
For more information, see the following sections.
3. Confirm that the backups are working.
It is important to verify your back up procedure by restoring a database. This ensures that your procedure is working when you come to use it in the future.
4. Periodically audit backups to ensure they are still working.
When performing the back up you can log the output to a file. You should periodically check the log for any errors.
Periodically, repeat step 3 to ensure the full back up procedure is still working.
Backing up a Running Database
We strongly recommend that you create regular backups of your databases. You can create backups of running databases using Model Explorer, ScfUtils, or SQL Server Agent. Backups must be performed on the SQL Server machine. You can truncate logs when a backup is done to recover disk space.
For more information, refer to the SQL Server help topic:
Backup Overview
Backing up a Model
You can use the export facility in Model Explorer to manually back up a model. For information about exporting and importing models, see the Model Explorer Help.
Was this helpful?