|
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.
|