Restore Overview
132 Agent for Microsoft SQL Server Guide
Restore Master Databases
Before you restore the master database, if the database files are missing, you
may need to either restore Microsoft SQL Server Disaster Recovery Elements for
that instance, or rebuild it using the Microsoft SQL Server Rebuild Master utility.
Restoring the master database requires that the restore operation have
exclusive access to the SQL Server instance. To ensure this, the Microsoft SQL
Server instance must be running in single-user mode. For complete instructions
on rebuilding your Microsoft SQL Server master database, see the Microsoft SQL
Server documentation.
Before restoring the master database, you must stop all applications which may
be using that instance of Microsoft SQL Server. This includes some secondary
services which are part of Microsoft SQL Server, such as the SQL Server
Automation Agent (“SQL Agent” service). The only exception to this is CA
ARCserve Backup itself; the Agent for ARCserve Database will ensure CA
ARCserve Backup is not using any ARCserve Database that the instance might
contain.
When you restore the master database, the Agent for Microsoft SQL Server
automatically detects this. The agent will restart Microsoft SQL Server in
Single-User Mode before executing the restore operation, and will return
Microsoft SQL Server to Multi-User Mode at the conclusion of the master
database restore.
Important!
You must stop
all
applications and services other than CA ARCserve
Backup that may be using databases in the Microsoft SQL Server instance for
which you are restoring the master database. Otherwise, one of these other
applications may re-connect to the SQL Server instance after it is restarted, and
prevent the agent from performing the restore.
