> 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
Del Hoobler
IBM Corporation
hoobler AT us.ibm DOT com

"It's a beautiful day.  Don't let it get away."  -- Bono