About Microsoft SQL Server recovery notes

The Backup Exec Agent for Microsoft SQL Server option must be installed on the media server in order to perform a complete SQL Server database recovery.

After using Intelligent Disaster Recovery to recover the Windows server, IDR automatically replaces the damaged master and model databases with copies of the master and model databases. After SQL is restarted and the latest master database backup and all other system databases are restored, you must still restore all user databases after completing the IDR Recovery.

Caution:

For the Intelligent Disaster Recovery Option to work with SQL 2000, copies are made of the master and model databases. Copies are made only after running non-AOFO (Advanced Open File Option) backups of the master and model databases. If you are using AOFO for SQL backups, you must make at least one backup of the master and model databases without using AOFO. If you upgrade SQL 2000, run another non-AOFO backup of the master and model databases.

More Information

Using snapshot technology with the SQL Agent

About the Advanced Disk-based Backup Option