> How should one handle the master DB? Should we just do daily fulls to be > safe? > > Also how do you handle your differential backups? Note the command in my > sqldiff.cmd file says to basically backup all DB's (i.e. *).. Do you go > and list each DB separately or somehow change dsm.opt so it excludes the > master DB from a differential backup (change my INCLUDE to EXCLUDE?)?
Gerald, You can only run full backups of the master database. That is how SQL Server works. If you want to make sure that your master database is safe, you should run full backups on it every day (or more often if you feel it is necessary.) As for your issue with the differential backups... How about using a different DSM.OPT file for the differential backups that EXCLUDE the master database from backup? So, you would have a DSM.OPT file that is used for the "FULL backups" that has no EXCLUDE statements and one that is used for the "DIFFERENTIAL backups" that EXCLUDEs the master database. Thanks, Del ---------------------------------------------------- Del Hoobler IBM Corporation [EMAIL PROTECTED] "It's a beautiful day. Don't let it get away." -- Bono
