December 3, 2007 at 5:30 am
Hi All, I am need of your help.
I have the below scenario and if somebody help me out on this regard, it would be helpful.
We have a production server and a DR server between which there is double take running. Log files are created in the DR server every 15 minutes. Now lets say the production server has crashed at 3 PM and we need to restore the DR to Production as it was before the crash. i have the database backup as of previous day also. how do we apply the logs accumulated on DR till the crash on the restored backup and make it sync as at 3 PM.
December 3, 2007 at 9:06 am
In our case we are using Double-Take to perform realtime replication of data and log files between production and DR. All that is needed if a production server dies is to rename the DR server and start the SQL Server services on the DR server. It is not necessary to restore DB or log backups when using Double-Take for realtime replication.
If you are using Double-Take to replicate the database and log backup files and not the data (mdf) and log (ldf) files then you need to restore the database backup and apply the transaction log backups up to the point-in-time of the production failure. BOL explains the process.
Dave
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply