Networker

Re: [Networker] 7.6.1 - Savesets hang

2011-02-07 15:09:57
Subject: Re: [Networker] 7.6.1 - Savesets hang
From: Michael Leone <Michael.Leone AT PHA.PHILA DOT GOV>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Mon, 7 Feb 2011 15:08:44 -0500
EMC NetWorker discussion <NETWORKER AT LISTSERV.TEMPLE DOT EDU> wrote on 
02/07/2011 02:55:36 PM:

> 
> savegrp -l incr -I HalfHourLogs
> 
> We run that command for a savegroup that included the SQL databases 
> we want log file type backups for as incremental.  We run a savegrp 
> -O to get the indexes once a day.  It only does incremental changes 
> (for us we run it every 30 min per the group name).

OK, not the type of backup I was referring to. I meant that if you define 
a client in NMC with saveset "MSSQL:"; backup command "nsrsqlsv", and 
install the SQL Module on the client - then regardless of the level of the 
group that client is in, the backup of the "MSSQL:" saveset would always 
be FULL., even if the group is on a schedule that specifies INCR.

I can't test it right now, but that's always been my understanding.

Yes, your way would be an incremental backup, but I don't think that works 
on the actual databases, the MDF files, does it? Those aren't INCR 
backups, are they?

The type of backup I refer to doesn't use "savegrp", it uses the 
"nsrsqlsv" command instead. I never do it manually, I just define it in 
NMC and let the system issue the actual command.

> 
> -----Original Message-----
> From: EMC NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU
> ] On Behalf Of Michael Leone
> Sent: Monday, February 07, 2011 2:42 PM
> To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
> Subject: Re: [Networker] 7.6.1 - Savesets hang
> 
> > We do incr for both Exchange and SQL using the SQL Module and NMM 
> > for Exchange..maybe you are using the Exchange Module and not NMM, 
> > but we have always done incr backups for SQL as "log" backups.
> 
> Not following you. I speak of a directive to backup "MSSQL:", and the "
> nsrsqlsv" as the backup command. Are you talking about doing an INCR 
> backup of the .TRN and .LOG files, as a regular filesystem backup?
> 
> I don't use NMM, no - I use the SQL Module. 
> 
> > 
> > -----Original Message-----
> > From: EMC NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU
> > ] On Behalf Of Michael Leone
> > Sent: Monday, February 07, 2011 1:59 PM
> > To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
> > Subject: Re: [Networker] 7.6.1 - Savesets hang
> > 
> > I thought you couldn't do an INCR backup when using the SQL Module - 
> that 
> > you would always get a FULL backup, regardless of level setting. And 
> that 
> > the EXCHANGE Modulet worked the same way - always a FULL backup of the 

> > Info Store. Reason being that both are database files.
> > 
> > Am I wrong about that?
> > 
> > FWIW - I run 7.5.2 (upgraded from 7.4.x) and use the SQL Module (both 
32 
> 
> > and 64bit), and have not seen any issues like you describe.
> > -- 
> > 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>
> > 
> > 
> > 
> > 
> > From:   Kevin Malone <KCMALONE AT SALISBURY DOT EDU>
> > To:     NETWORKER AT LISTSERV.TEMPLE DOT EDU
> > Date:   02/07/2011 01:14 PM
> > Subject:        Re: [Networker] 7.6.1 - Savesets hang
> > Sent by:        EMC NetWorker discussion 
<NETWORKER AT LISTSERV.TEMPLE DOT EDU>
> > 
> > 
> > 
> > I am running 7.5.3.2 and have been experiencing SQL backup hangs ever 
> > since I upgraded to this version from 7.4.4 over 3 months ago.  I have 

> > seen hangs on log file (incr) backups of SQL and failures on 
> differential 
> > and full backups with errors being i/o 995 errors.  We have not been 
> able 
> > to isolate the issue as of yet, and EMC engineering has been looking 
> into 
> > this for some time.  This does not happen with traditional file level 
> > backups for the same servers, only with SQL.  We can backup SQL to a 
> local 
> > file and then backup that file with no errors.  We use the SQL Module. 
I 
> 
> > have tried lots of combinations of older SQL clients and older NW 
client 
> 
> > versions and are now down to only a couple of clients that have this 
> > behavior having downgraded to SQL Module versions 5.0 (for SQL 2005) 
or 
> > 5.1 (for SQL 2008).  This issue happens across all Microsoft OS 
> versions, 
> > all SQL versions (2005 and 2008) and both 32 and 64 bit.
> > 
> > I know this isn't the same issue as yours, Dave, but I am curious if 
> > anyone else out there is seeing similar issues with backups 
> > hanging/erroring with i/o 995. 
> > 
> > Kevin Malone
> > Salisbury University
> > Salisbury, Maryland
> > 
> > 
> > 
> > -----Original Message-----
> > From: EMC NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT 
> > EDU] 
On 
> 
> > Behalf Of Werth, Dave
> > Sent: Monday, February 07, 2011 12:52 PM
> > To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
> > Subject: [Networker] 7.6.1 - Savesets hang
> > 
> > We are running NetWorker 7.6.1 Server on Windows 2008 R2 Server.  This 

> was 
> > installed a week ago last Friday.  Our old server was 7.5.2.
> > 
> > I know this has been discussed before and I've spent some time 
searching 
> 
> > the archives and the EMC PowerLink Knowledge Base without much luck.
> > 
> > The problem is that on a somewhat random basis different savesets hang 

> > during backups, usually the bigger ones that take longer to backup.  I 

> can 
> > often restart them by going onto the client and killing the save 
process 
> 
> > but sometimes they hang again.  Our clients are a mixture of 7.5 and 
7.6 
> 
> > which doesn't seem to make a difference to the problem.
> > 
> > Can anyone offer some help to me with the problem?
> > 
> > Thanks,
> > Dave Werth
> > Garmin AT, Inc.
> > Salem, Oregon
> > 
> > ________________________________
> > This e-mail and any attachments may contain confidential material for 
> the 
> > sole use of the intended recipient. If you are not the intended 
> recipient, 
> > please be aware that any disclosure, copying, distribution or use of 
> this 
> > e-mail or any attachment is prohibited. If you have received this 
e-mail 
> 
> > in error, please contact the sender and delete all copies.
> > 
> > Thank you for your cooperation.
> > 
> > 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
> 
> 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