Hello,
Normally, recovering SQL Server after a complete Disaster Recovery requires
two steps: Recover SQL ServerâÃâ¬Ãâ¢s System Databases and then recover the User
databases. With Backup Exec 9.x, this is reduced to one step: Recovering
the User databases. Backup Exec backs up the system databases during file
backups as off-line files (system databases are usually small) and the IDR
option restores them âÃâ¬Ãâ allowing you to skip a step in the disaster recovery
process and save valuable time.
Hence, the only step left is to restore the suser databases. To do this,
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. 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.
Hope this clarifies.
NOTE : If we do not receive your reply within two business days, this post would be marked assumed answered and would be moved to answered questions pool.