Luc,
I have this in my DSM.OPT file:
EXCLUDE \...\master\...\log*
Here is the output when I try to back up the log of master:
-
C:\Program Files\Tivoli\TSM\TDPSqltdpsqlc backup master log
IBM Tivoli Storage Manager for Databases:
Data Protection for
Hi all
I'm doing SQL LOG backup every 6 hours and a full backup every day ...
I got a failed status everytime cause I can not take theLOG backup of the
master DB ...
This is the command that I launch ...
%sql_dir%\tdpsqlc backup * log /tsmoptfile=%sql_dir%\dsm.opt
/logfile=%sql_dir%\sqllog.log
.
Phone: 416-235-0931 x26
Fax: 416-235-0265
Web: www.infinitynetwork.com
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Luc Beaudoin
Sent: Tuesday, November 30, 2004 11:56 AM
To: [EMAIL PROTECTED]
Subject: scheduled SQL log backup question
Hi all
To: [EMAIL PROTECTED]
cc:
Subject:Re: scheduled SQL log backup question
I think you cannot take log backup of master db; only full; that doesn't
matter, it is small database (but very important)
In your script put tdpsqlc backup db1,db2,db3,db4 log .
Db1,db2
Manager
To: [EMAIL PROTECTED]
cc:
Subject:Re: scheduled SQL log backup question
I think you cannot take log backup of master db; only full; that doesn't
matter, it is small database (but very important)
In your script put tdpsqlc backup db1,db2,db3,db4 log
, or harvest
them and grow stronger
-Original Message-
From: Del Hoobler [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 30, 2004 1:55 PM
To: [EMAIL PROTECTED]
Subject: Re: scheduled SQL log backup question
Luc,
This is a known requirement that has been submitted and being
prioritized
: Tuesday, November 30, 2004 1:55 PM
To: [EMAIL PROTECTED]
Subject: Re: scheduled SQL log backup question
Luc,
This is a known requirement that has been submitted and being
prioritized for a future release, i.e. allowing you to
exclude certain databases from a command.
Thanks,
Del
PROTECTED]
Subject: Re: scheduled SQL log backup question
Luc,
This is a known requirement that has been submitted and being
prioritized for a future release, i.e. allowing you to
exclude certain databases from a command.
Thanks,
Del
ADSM