Sunday, February 12, 2012

Backup Transaction Log to 2 different location

hi,
is there a possibility do backup the transaction log to 2 different
locations, and to handle them separatly when restoring a database?
The thing i want to do is, to be able to restore the database on 2
different location without doing logshipping.
thx for your help.Hi
No. After the backup, do a XCOPY to the alternative location.
Regards
Mike
"Donald" wrote:

> hi,
> is there a possibility do backup the transaction log to 2 different
> locations, and to handle them separatly when restoring a database?
> The thing i want to do is, to be able to restore the database on 2
> different location without doing logshipping.
> thx for your help.
>|||When I've done this I've always implemented it as an external app (VB
based). Not too hard to do.
"Donald" <martin.ha@.gmx.net> wrote in message
news:enCcG$QDFHA.3732@.TK2MSFTNGP14.phx.gbl...
> hi,
> is there a possibility do backup the transaction log to 2 different
> locations, and to handle them separatly when restoring a database?
> The thing i want to do is, to be able to restore the database on 2
> different location without doing logshipping.
> thx for your help.

No comments:

Post a Comment