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\TDPSql>tdpsqlc backup master log
IBM Tivoli Storage Manager for Databases:
Data Protection for Microsoft SQL Server
Version 5, Release 2, Level 1.0
(C) Copyright IBM Corporation 1997, 2003. All rights reserved.
Starting SQL database backup...
Total SQL backups selected: 1
Total SQL backups attempted: 0
Total SQL backups completed: 0
Total SQL backups excluded: 1
Throughput rate: 0.00 Kb/Sec
Total bytes transferred: 0
Elapsed processing time: 0.00 Secs
--------------------------------------------------------------
Notice that "master" was excluded from "log" backup.
Can you paste the output of the execution of your
command-line invocation? i.e.
tdpsqlc backup master log
As far as the GUI is concerned...
The specialized code to "EXCLUDE" it from consideration
exists in the command-line only. The GUI does not grey
it out if it is EXCLUDEd by a DSM.OPT EXCLUDE statement.
(Probably a good enhancement to make.)
However, if it is eligible for backup as far as SQL is concerned,
it will still be excluded from TSM backup since the TSM API will
reject it due to the EXCLUDE statement.
In this GUI case for a log backup of the master, you will get the
error message from SQL.
Thanks,
Del
----------------------------------------------------
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 12/02/2004
04:22:47 PM:
> Hi All
>
> I want to EXCLUDE the LOG BACKUP of the MASTER DB
>
> I went in the dsm.opt file in the \TDPsql folder, and I removed the * in
> front of the :
>
> EXCLUDE "\...\master\...\log*"
> EXCLUDE "\...\msdb\...\log*"
>
> But it still try to take it ....
> When there is a exclude , if I go in the SQL GUI and try to do a Backup
of
> the all SQL DB ... then I select the server for all DB... and the MASTER
> is not grayed out
>
> Any idea why ???
>
> Thanks
>
> Luc
|
