Document ID: 284984
http://support.veritas.com/docs/284984
E-Mail Colleague IconE-Mail this document to a colleague

Backup Exec Remote Intelligent Disaster Recovery (RIDR) does not recover Microsoft SQL 2005 Master or Model databases automatically.

Details:

When performing Remote Intelligent Disaster Recovery (RIDR), Backup Exec will not recover the master/model databases of SQL 2005 automatically.

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 IDR 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, the latest master database backup and all other system databases are restored.
All user databases must also be restored after completing the IDR Recovery.

Workaround:
Restore the master/model SQL databases manually:
Permanent Fix:
This issue has been resolved in Hotfix 37 for Backup Exec 10.1.5629
http://support.veritas.com/docs/285069


Supplemental Material:

System: Ref.#Description
ETrack: 538352 RIDR doesn't recover master/model DB of SQL2005 automatically

Acknowledgements
Backup Exec Administrators Guide

Products Applied:
 Backup Exec for Windows Servers 10d (10.1)

Last Updated: September 19 2006 08:44 PM GMT
Expires on: 365 days from publish date
Subscribe Via E-Mail IconSubscribe to receive critical updates about this document

Subjects:
 Backup Exec for Windows Servers
   Intelligent Disaster Recovery: Known Issues

Languages:
 English (US)

Operating Systems:
Windows Server 2003

DataCenter, Enterprise Server, Standard Server