If you just restored a server, moved a server to another computer, reinstalled or upgraded SQL Server, or made some configuration mistakes that you want to undo, you can restore the old database.
Before you begin
What you should know
NOTE: The following cases
are exceptions:
- You cannot restore the Directory database from Server Admin when the Mirroring failover mode is enabled. For more information on the restrictions regarding backup and restore while the database mirroring session is active, refer to the Microsoft SQL Server Database Mirroring documentation.
- For the Archiver and the Auxiliary Archiver roles, after restoring the role database, you must also restore the video archives.
Procedure
-
Click Backup/Restore (
).
For the Directory database, you would click Backup/Restore (
) from Server Admin. -
In the Backup/Restore dialog box, beside the Restore
file field, click Select file (
), and select the backup file you want to restore.
NOTE: By default, databases are backed up to C:\SecurityCenterBackup on the database server, and configuration files are backed up to the same folder on the server hosting the role. If your backups are stored on a shared network drive, enter the path manually, and ensure that the service user has read access to that location.