ADSM-L

TDP for MSSQL problem

2001-11-19 15:03:11
Subject: TDP for MSSQL problem
From: Gerald Wichmann <gwichmann AT SANSIA DOT COM>
Date: Mon, 19 Nov 2001 12:00:41 -0800
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)
<Prev in Thread] Current Thread [Next in Thread>