Managing the Database and Reporting › How to Protect the Arcserve Backup Database › How to Recover the Arcserve Database When the SQL Server Instance Hosting the Arcserve Database is Not Functional

How to Recover the Arcserve Database When the SQL Server Instance Hosting the Arcserve Database is Not Functional

A typical disaster recovery scenario consists of the following steps:

1. Reinstall Windows, if necessary.
2. Reinstall 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 rebuildm.exe utility, use the utility to recreate the master and model database. 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 all other databases and transaction logs, except the replication database.
9. If replication is being used, restore the replication database.