Networker

Re: [Networker] Report on databases within a saveset of a MSSQL: instance

2009-12-09 08:23:25
Subject: Re: [Networker] Report on databases within a saveset of a MSSQL: instance
From: James Pratt <jpratt AT NORWICH DOT EDU>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Wed, 9 Dec 2009 08:07:49 -0500
I'm not sure if this still applies, but it seems to make sense - I have
not found a way using the MSSQL: saveset value myself either. 

http://www.adsm.org/lists/html/Networker/2008-05/msg00268.html

regards,
james

>> -----Original Message-----
>> From: EMC NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU]
On
>> Behalf Of JKK
>> Sent: Wednesday, December 09, 2009 6:24 AM
>> To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
>> Subject: [Networker] Report on databases within a saveset of a MSSQL:
instance
>> 
>> Hi.
>> 
>> Does anyone know how to get report information on per database within
an
>> MSSQL: instance with NetWorker 7.5.1?
>> 
>> I would like to get a list of backups only for db1 and db2 withing
the
>> MSSQL$SQL2005: instance on the database server.
>> 
>> If I run mminfo I only get a list of instance names. Also, the
instance
>> name is listed up many times, probably one line for each database.
But I
>> would like to see the name of the database:
>> 
>> for example
>> 8.12.2009 52 MB MSSQL:                        656324473   incr
>> 8.12.2009 9034 KB MSSQL:                      589215620   incr
>> 8.12.2009 26 MB MSSQL:                        555661193   incr
>> 8.12.2009 478 KB MSSQL:                       505329551   incr
>> 8.12.2009 54 KB MSSQL:                        471775123   incr
>> 8.12.2009 3092 KB MSSQL:                      421443478   incr
>> 
>> Here are different ssid's, probably one for each database within the
MSSQL:
>> instance. Is it possible to have networker display the name of the
database?
>> 
>> Johannes
>> 
>> 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 with 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 with 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