Networker

Re: [Networker] Does SQL backup prune transaction logs after backup?

2003-01-02 12:23:01
Subject: Re: [Networker] Does SQL backup prune transaction logs after backup?
From: Matthew Bourne <mbourne2001 AT LYCOS.CO DOT UK>
To: NETWORKER AT LISTMAIL.TEMPLE DOT EDU
Date: Thu, 2 Jan 2003 12:23:25 -0500
Hello Ragu,

No, not with your settings as they stand.

The SQL module can prune your transaction log for you, but it's a bit
fiddly to set up.  Rather than using the "MSSQL" saveset, you have to
specify individual database names, and back them up incrementally.

An incremental backup done with the SQL module backs up all the changes to
the database, allowing point-in-time restores, and then truncates the
transaction log.  Trouble is, as I said, you can't run an incremental
backup of MSSQL.  You can get the names of your databases from the nsrinfo
command by running "nsrinfo -n mssql clientname".

Sorry if this is a bit garbled, I spent a couple of months looking at this
towards the end of last summer.  If you want any clarification then please
reply to the list.

Happy New Year.

Matthew

--
Note: To sign off this list, send a "signoff networker" command via email
to listserv AT listmail.temple DOT edu or visit the list's Web site at
http://listmail.temple.edu/archives/networker.html where you can
also view and post messages to the list.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=

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