MSQL: type backup will do transaction log backups fine when set to incr, but
System databases will always be full as you can not change their logtype from
simple.
Johannes Mattila
IT-avdelningen, Tullverket
(0920 259623/070 6725315)
-----Ursprungligt meddelande-----
Från: EMC NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU]
För Kevin Malone
Skickat: den 7 februari 2011 21:14
Till: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Ämne: Re: [Networker] 7.6.1 - Savesets hang
Sorry...I left out that we do not use "MSSQL:", we put in the databases
individually so that we can do the incr backups. so that is the
difference.....my fault for not giving all the details. And yes, we have
nsrsqlsv in the command.
-----Original Message-----
From: EMC NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU] On
Behalf Of Michael Leone
Sent: Monday, February 07, 2011 3:09 PM
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Subject: Re: [Networker] 7.6.1 - Savesets hang
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
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
|
