You cannot backup SQL in this manner unless SQL is stopped.  You will end up
with corrupted data because of uncommitted transactions not to mention other
things.  This is why there is a module specifically for SQL backups.  We
don't actually use the module instead relying on SQL backups to disk
containers which we then backup with Networker.



You can get a saveset's contents this way.

First find the savetime and client name by passing the ssid to mminfo:
NOTE: savetime is not a timestamp it's an integer.

Mminfo -av -q ssid=<ssid> -r "nsavetime,client"

Then pass this info to nsrinfo:

Nsrinfo -V -t <savetime> <client>


--Shawn


-----Original Message-----
From: EMC NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU] On
Behalf Of Stella Hays
Sent: Thursday, September 21, 2006 11:09 AM
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Subject: [Networker] Microsoft SQL Database

First, I have been backing up a window's server that runs Microsoft SQL 
databases.  The disk that the databases were on was deleted. We are not 
able to find all the .ldf and .mdf files.  Are we not backing up all these 
files?  The databases are not being stopped.  So I would guess the files 
are open.  I did not receive any mail saying "The process cannot access the 
file because it is being used by another process".  This happen when the 
file is open, correct?  The server that is performing the backup is running 
Solairs 9 with Legato 7.2.

Second,  is there a report I can run that can show me what is being backed 
up?  Is this in a log file somewhere?

Please Help!

To sign off this list, send email to listserv AT listserv.temple DOT edu and 
type
"signoff networker" in the
body of the email. Please write to networker-request AT listserv.temple DOT edu 
if
you have any problems
wit this list. You can access the archives at
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER

To sign off this list, send email to listserv AT listserv.temple DOT edu and 
type "signoff networker" in the
body of the email. Please write to networker-request AT listserv.temple DOT edu 
if you have any problems
wit this list. You can access the archives at 
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER