12-09-2013 07:16 AM
My previous employer did disk to disk native SQL Server backup which I was very comfortable using for SQL Server backup/recovery.
My new employer uses NetBackup 7.5.0.6 for to back up SQL Servers to tape. I am not sure how I feel about backing up Master and MSDB to tape. If the SQL Server crashes and I need to rebuild a new one, am I able to reliably recover these system databases to a different machine? I'm a little nervous relying on a 3rd party tool and it's limitations. Do you folks make extra backups somewhere to disk for these system databases using a "copy only" native SQL Server backup for easier recovery?
Solved! Go to Solution.
12-09-2013 08:54 AM
if in ur scripts .bch files u have selected option $ALL then all the system databases are also backedup.
master model msdb .if u know how to restore SQL database then u can also restore system database as well. make sure SQL instance is in single user mode.
use this link http://www.symantec.com/business/support/index?page=content&id=TECH31071
12-09-2013 08:54 AM
if in ur scripts .bch files u have selected option $ALL then all the system databases are also backedup.
master model msdb .if u know how to restore SQL database then u can also restore system database as well. make sure SQL instance is in single user mode.
use this link http://www.symantec.com/business/support/index?page=content&id=TECH31071
12-10-2013 06:20 AM
Yes, we are backing up the system databases like that. The issue I am concerned about is restoring system databases to a DIFFERENT server.
12-10-2013 07:01 AM
if u know how to restore SQL database then u can also restore system database as well. make sure SQL instance is in single user mode.
use this link http://www.symantec.com/business/support/index?page=content&id=TECH31071