Backing up an MSSQL DB with the TDP for MSSQL v2.1.. I've read through the users guide and didn't see anything specific on how to handle backing up the master database other then one section that simple states that it's important to do so. It also said when to do it and lists a set of commands that if those are used, you apparently should do a backup of the master DB.
We were going to do a Full backup of all our databases on Sundays and differentials the rest of the week (M-Sa), however it looks like the differential backups are failing. Well sort of. All the databases are backing up except the master database which gripes that you can't do a differential backup of the master DB. 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?)? All in all I see my problem but I'm not sure what the best way is to handle it. Thanks :-) Dsm.opt: INCLUDE "\...\master\...\full*" SqlDbMSClassFull INCLUDE "\...\master\...\diff*" SqlDbMSClassDiff Sqldiff.cmd %sql_dir%\tdpsqlc backup * diff /tsmoptfile=%sql_dir%\dsm.opt /logfile=%sql_dir%\sqldiff.log >> %sql_dir%\sqlsched.log sqldiff.log: 11/19/2001 12:17:47 ============== Log file pruned using log retention period of 60 day(s) 11/19/2001 12:17:47 ============== No log entries pruned 11/19/2001 12:17:48 ======================================================================== = 11/19/2001 12:17:49 ======================================================================== = 11/19/2001 12:17:49 Request : DIFF BACKUP 11/19/2001 12:17:49 Database Input List : * 11/19/2001 12:17:49 Group Input List : - 11/19/2001 12:17:49 File Input List : - 11/19/2001 12:17:49 Number of Buffers : 3 11/19/2001 12:17:49 Buffer Size : 1024 11/19/2001 12:17:49 Number of SQL Buffers : 0 11/19/2001 12:17:49 SQL Buffer Size : 1024 11/19/2001 12:17:49 Number of Stripes specified : 1 11/19/2001 12:17:49 Estimate : 20 11/19/2001 12:17:49 Truncate Log? : - 11/19/2001 12:17:49 Wait for Tape Mounts? : Yes 11/19/2001 12:17:49 TSM Options File : C:\Progra~1\Tivoli\TSM\TDPSql\dsm.opt 11/19/2001 12:17:49 TSM Nodename Override : - 11/19/2001 12:17:49 Sqlserver : GRAND 11/19/2001 12:17:49 11/19/2001 12:22:02 Backup of master failed. 11/19/2001 12:22:02 ACO5422E Received the following from the MS SQL server: 11/19/2001 12:22:02 [Microsoft][ODBC SQL Server Driver][SQL Server]You can only perform a full backup of the master database. Use BACKUP DATABASE to back up the entire master database. 11/19/2001 12:22:02 [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally. Microsoft SQL-DMO (ODBC SQLState: 42000) (HRESULT:0x80040bd0) 11/19/2001 12:23:02 Total SQL backups selected: 15 11/19/2001 12:23:02 Total SQL backups attempted: 15 11/19/2001 12:23:02 Total SQL backups completed: 14 11/19/2001 12:23:02 Total SQL backups excluded: 0 11/19/2001 12:23:02 Throughput rate: 3,662.73 Kb/Sec 11/19/2001 12:23:02 Total bytes transferred: 1,154,389,728 11/19/2001 12:23:02 Elapsed processing time: 307.78 Secs 11/19/2001 12:23:02 ACO0151E Errors occurred while processing the request. Gerald Wichmann System Engineer StorageLink 408-844-8893 (v) 408-844-9801 (f)
