September 30, 2003 at 11:52 pm
I configured SQL server LogShipping, details as follows
Primary Server - DBServ1
Secondary Server - DBServ2
Monitor server - AdminServ
Transaction loag Back up : every 10 minutes
Copy/Load :every 10 Minutes
The problem is that the database in the primary server is in suspect state (because of some problem with the disk)
i configured the secondary server as standby server. now i want to make the secondary server to function as primary and i dont know how to do that...(secondary server is readonly now i want to make it as read/write)
pls help
October 1, 2003 at 12:48 am
To bring the standby database out of read only execute the following
restore database <<database name>> with RECOVERY
Make sure you have applied all the necessary transaction logs/differentials beforehand! Because once the database as been restored you cannot apply any more logs.
October 1, 2003 at 9:44 am
quote:
To bring the standby database out of read only execute the followingrestore database <<database name>> with RECOVERY
Make sure you have applied all the necessary transaction logs/differentials beforehand! Because once the database as been restored you cannot apply any more logs.
Thanks a lot, it is working, thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply