Changing over to DR database from SQL 2005
I have set up log shipping from my production SQL2005 databases to my DR server and all seems to be working fine.
On examing my DR databases they are all in (Restoring...) mode. How do I now access my DR databases if/when my production system goes down? There does not seem to be any obvious task to do this.
Any help would be much appreciated!
Software/Hardware used:
MS SQL2005 on HP DL380 servers
On examing my DR databases they are all in (Restoring...) mode. How do I now access my DR databases if/when my production system goes down? There does not seem to be any obvious task to do this.
Any help would be much appreciated!
Software/Hardware used:
MS SQL2005 on HP DL380 servers
ASKED:
June 28, 2010 5:39 AM
UPDATED:
June 28, 2010 7:36 PM
Answer Wiki:
You have to restore the tail last of the log files that you have available, then bring the database online via:
<pre>RESTORE LOG YourDatabase WITH RECOVERY</pre>
This will bring the database back online. To then move back to production, you have to setup log shipping in the other direction, then switch everyone over.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
