Specifications

378 Module 137: System Commissioning | Backing up and Restoring a Database
8. You should now have the backup file listed under the backup sets to restore. Select (enable) the Restore
check box beside the backup set.
When performing a backup, if the file already exists, SQL appends the backup to the same file as an
additional backup set. If multiple backup sets are shown, select the set with the most recent date.
9. Click the Options page and ensure the Restore options are set to Overwrite the existing database.
If you don't select this, you will just add the backup set to the end of the existing database which will result
in corruption of the database.