Most likely explanations: Either the file is not getting backed up when
you think it is, or else it's being overlooked by whoever is looking in
the dsmsched.log file.

For starters, it would help to know the following:

1) Complete dsmsched.log content (zip up and attach, be sure to point out
the date/time when you think the file should be getting backed up)

2) Complete output from:

   dsmc q ba c:\path\to\file.mdf -ina

(you fill in the path name the the .mdf file in question)

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.eyebm DOT com (change eye to i to reply)

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.




Jim Kirkman <jmk AT EMAIL.UNC DOT EDU>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
03/10/2003 09:42
Please respond to jim_kirkman


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Schedlog entries?



We've got a W2K box running the 5.1.5.0 client and backing up a MS-SQL
database to our 4.1.4.2 server. In lieu of the TDP we're stopping and
starting the sqlserver with the pre/post schedule command and batch
files. I've applied a specialized MC to the primary .mdf file and can
see from the web interface that it's applied, backing up, and keeping
the correct number of copies. So everything seems cool, except that the
admin for this box likes to check the schedlog to verify the backups,
and it has entries for all the files in the sql\data directory except
the one with the separate mc applied. Anyone know why that would be?

thanks,

--
Jim Kirkman
AIS - Systems
UNC-Chapel Hill
966-5884