Networker

Re: [Networker] Identifying a MS SQL database using mminfo

2008-05-22 10:52:54
Subject: Re: [Networker] Identifying a MS SQL database using mminfo
From: MIchael Leone <Michael.Leone AT PHA.PHILA DOT GOV>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Thu, 22 May 2008 10:45:46 -0400
"Venkat Tudi" <venkat.tudi AT gmail DOT com> wrote on 05/22/2008 10:40:29 AM:

> 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.

Ratz. Yeah, I don't explicitly list database names, because - not being 
the database admin - I never know when there will be a new database added, 
that needs to be backed up. So I just tell all the database servers to 
backup MSSQL: (I have a dozen or more servers, between development and 
production servers).

Ah, well.

Thanks

> 
> -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

<Prev in Thread] Current Thread [Next in Thread>