Microsoft SQL Server Disaster Recovery
100 Agent for Microsoft SQL Server Guide
Disaster Recovery Scenario
A typical disaster recovery scenario consists of the following steps:
1.
Reinstall Windows, if necessary.
2.
Reinstall CA ARCserve Backup, if necessary.
3.
Reinstall the Agent for Microsoft SQL Server and the Client Agent for
Windows, if necessary. (The Client Agent is needed to restore Microsoft SQL
Server Disaster Recovery Elements.)
4.
Perform one of the following steps as appropriate:
■
If you have a Microsoft SQL Server Disaster Recovery Elements session,
restore it.
■
If an offline backup exists, restore it.
■
If you do not have an offline backup or a Disaster Recovery Elements
session, and you have the Microsoft SQL 7.0 or 2000 rebuildm.exe
utility, use the utility to recreate the master and model database. For
SQL 2005 and 2008, this is an ability of the SQL Server installation
software. For more information, see the Microsoft documentation.
■
If an offline backup or Disaster Recovery Elements backup do not exist
and you do not have the Microsoft SQL rebuildm.exe utility, reinstall the
Microsoft SQL Server or MSDE-based application.
5.
Restore the [master] database.
6.
Restart Microsoft SQL Server in normal, multi-user mode.
7.
Restore the [msdb] database.
8.
Restore the model database.
9.
Restore all other databases and transaction logs, except the distribution
database for replication.
10.
If replication is being used, restore the replication database.