Hi Thierry.
This works for me, brilliant!
Thanks,
Johannes
-----Original Message-----
From: EMC NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU] On
Behalf Of Thierry FAIDHERBE
Sent: 10. desember 2009 11:07
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Subject: Re: [Networker] Report on databases within a saveset of a MSSQL:
instance
Well, you can do it as following :
from mminfo, gather nsavetime of your mssql backups.
then, call for each nsavetime :
nsrinfo -n MSSQL -t {BACKUPTIME} client_sql_db
in first lines, you can retrieve complete MSSQL db name.
Good luck
Th
>> -----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
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
|