cancel
Showing results for 
Search instead for 
Did you mean: 

Restore SQL DB level tape backup on different Backup Exec 2014 Server

Dammz
Level 2
Partner

Hello

I have deployed Backup Exec 2014 server and scheduled the backup jobs as follow.

  1. Full Backup of Backup Exec 2014 Server (External Hard disk) - Weekly
  2. Virtual Machine Conversion: Domain Server (External Hard disk) - Weekly
  3. Virtual Machine Conversion: SQL Server (External Hard disk) - Weekly
  4. SQL Database Level Backup (Tape) - Daily

And above backups will be tested on separate network. (DR)

  1. Restore Backup Exec Server - Weekly
  2. Restore Domain Server VM - Weekly
  3. Restore SQL Server VM - Weekly
  4. Restore SQL DB - Daily

My concern is when restoring SQL DB daily, should I need to copy Backup Exec Catalogs (C:\Program Files\Symantec\Backup Exec\Catalogs) manually or is it possible to include catalogs on the same tape backup job which is running daily?

Regards,

Dammz

 

3 REPLIES 3

pkh
Moderator
Moderator
   VIP    Certified
The catalog is only produced at the end of the job so including the catalog directory in the same job will not save the catalog of the job It is better to catalog the tape on your DR server

Dammz
Level 2
Partner

So the only way is to copy it manually and restart the Backup exec services, correct?

pkh
Moderator
Moderator
   VIP    Certified
Yes. It might be faster to just catalog the tape