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!
MS SQL2005 on HP DL380 servers
June 28, 2010 5:39 AM
June 28, 2010 7:36 PM