cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Server - what do you folks do for Master and MSDB databases?

A_J_A
Level 3

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?

 

 

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

rookie11
Moderator
Moderator
   VIP   

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

View solution in original post

3 REPLIES 3

rookie11
Moderator
Moderator
   VIP   

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

A_J_A
Level 3

Yes, we are backing up the system databases like that. The issue I am concerned about is restoring system databases to a DIFFERENT server.

rookie11
Moderator
Moderator
   VIP   

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