| Ken Nickels 2002-06-25, 2:25 pm |
| Two possibilities. For realtime storage of "live" transaction logs, you
could mirror the file with NT or hardware RAID, or you could use
<xp_cmdshell "copy <txDump1.bak txDump2.bak"> to copy the transcation log
dump to another dump file. Not realtime, but better than log shipping, which
seems to be overkill in your situation.
"Kent Fong" <hkfong@hotmail.com> wrote in message
news:606d01c20229$368c1520$37e
f2ecf@TKMSFTNGXA13...
> Dear professionals,
>
> I am new to SQL server 2000. Thank you very much for your
> help in advance.
> In SQL server 2000, transaction log are used to record the
> changes made to database since last full backup or
> transaction log backup, nearly have the same function as
> redo logs of Oracle. I am now performing transaction log
> backup every hour. However, since the data chnages make to
> database are important to me, I would like to ask how to
> build two destinations of identical transaction log copy
> of the database such as the ARCHIVE_DUPLEX_DEST at Oracle.
> It is because I would like to keep two identical,
> simultaneous and real time copy of transaction log between
> each transaction log backup.
> I find that it is a technique called 'log shipping', but
> it required to set another server. So, is there any
> technique to keep two identical real time copy of
> transaction log in the database.
> Thank you very much for your help.
> Yours,
> Kent Fong
>
|