Thx, Mathew. Incremental is not an option for me. The
SQL admin said he will find out a way within SQL.
Ragu

--- Matthew Bourne <mbourne2001 AT LYCOS.CO DOT UK> wrote:
> 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.
>
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

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