SQL Server - what do you folks do for Master and MSDB databases?
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?
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