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.
Sunday, February 12, 2012
Backup Transaction Log to 2 different location
Labels:
backup,
database,
databasethe,
differentlocations,
handle,
location,
log,
microsoft,
mysql,
oracle,
possibility,
restoring,
separatly,
server,
sql,
transaction
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment