Microsoft SQL Server Disaster Recovery
98 Agent for Microsoft SQL Server Guide
Additional Database Status Considerations
Database Status -- Mirror
When the entire instance is selected, Mirror databases do not appear on the
database list, and are ignored. For a Mirror database to be explicitly selected
for backup, it would have been selected while it was the Principal (Active)
member of the Mirroring partnership, and entered the Mirror state due to a
subsequent fail-over.
Database Status -- Suspect
When a database using the Full or Bulk-Logged Recovery Model is in the
Suspect state, the Agent automatically attempts to perform a Transaction
Log Backup with No Truncation. If this matches the backup options selected,
then the results of this backup are the only indicator. If a different backup
method is selected, a Warning is posted that a Transaction Log Backup with
No Truncation is being attempted instead of using the selected options.
Database Status -- Missing
Because the database list is enumerated dynamically when the entire
instance is selected, the Agent for Microsoft SQL Server has no knowledge of
databases that have been removed from the SQL Server instance.
Microsoft SQL Server Disaster Recovery
The Agent for Microsoft SQL Server uses the Microsoft SQL Server Backup and
Restore database functions, but these functions do not actually back up the
physical files that make up the database. Consequently, for a restore operation
to succeed, the database instance must be online.
The Master Database
For Microsoft SQL Server to run, the master database must be set up as follows:
■
A master database and a model database
must
exist.
■
To have a master and a model database, you must either reinstall Microsoft
SQL Server, rebuild the master database using Microsoft SQL Server setup,
or restore either a Microsoft SQL Server Disaster Recovery Elements session
or an offline copy of the master database from media.
■
After the master and model databases exist, Microsoft SQL Server must be
running to execute the Restore command.
After you restore SQL Disaster Recovery Elements, you should immediately
perform a normal restore of the master, msdb, and model databases. To restore
the master database, Microsoft SQL server must be running in single-user mode.
For more information about restoring the master database, see
Restore Master
Databases.
(see page 132)
