Michael,
I don't think you can. The reason is your savset is set MSSQL; if you would
have backed-up with savset MSSQL: PROD, MSSQL: UPGRADE then you can.

-Venkat

On Thu, May 22, 2008 at 10:15 AM, MIchael Leone <Michael.Leone AT pha.phila DOT 
gov>
wrote:

> I have this MS SQL2005 database server that we backup using the NW SQL
> module. This server is an AFTD device, and so it writes the backup to
> disk. I need to delete one of those databases, to clear up room.
>
> However, when I run
>
> mminfo -r
> "ssid,cloneid,client,name,savetime(22),totalsize(2),copies,ssflags,clflags"
> -q "client=%machine%,volume=%tapevol%"
>
> I get back:
>
> .
> 4264871542  1211418229 pssql3    MSSQL: 5/21/2008 9:03:50 PM 131 GB 3 vF
> 2570380296  1211425799 pssql3    MSSQL:                          5/21/2008
> 11:10:00 PM 130 GB 3 vF
> 2436164230  1211427461 pssql3    MSSQL:                          5/21/2008
> 11:37:40 PM 678 MB 3 vF
> 2419387087  1211427535 pssql3    MSSQL:                          5/21/2008
> 11:38:55 PM 169 GB 3 vF
> 2385834317  1211429196 pssql3    MSSQL:                          5/22/2008
> 12:06:35 AM 3093 KB 3 vF
> 2369057104  1211429199 pssql3    MSSQL:                          5/22/2008
> 12:06:39 AM 1515 KB 3 vF
> 2352279890  1211429201 pssql3    MSSQL:                          5/22/2008
> 12:06:42 AM 31 MB 3 vF
> 2335502677  1211429204 pssql3    MSSQL:                          5/22/2008
> 12:06:44 AM 464  B 3 vF
>
> How can I have NW tell me exactly what the database name is? One is named
> PROD, and one is UPGRADE (temp db used during a recent upgrade), and I'd
> like to make sure which one I am deleting. :-)
>
> I'm assuming that the savesets follow the order of the backup, which
> according the the SQL module backup log, would mean the 2nd set shown
> above. But how can I verify that? I can't seem to find a way to have
> mminfo tell me the database name, so I can double check what I'm deleting.
>
> NW 7.4 SP2 on Win2003; NW SQL module 5.1 SP1.
>
> Thanks!
>
> --
> Michael Leone
> Network Administrator, ISM
> Philadelphia Housing Authority
> 2500 Jackson St
> Philadelphia, PA 19145
> Tel:  215-684-4180
> Cell: 215-252-0143
> <mailto:michael.leone AT pha.phila DOT gov>
>
> 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
>



-- 
Venkat Tudi

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