Hai All,

 I am Trying to configer  the Standby server in sql server 2005, i sucuess fully configer, but i hae onr problem how to change standby server to normal sever ? in this one document is i got it in that they are told it is by manually doing in that they are told run the some scripts but in sql server 2005 there is no "DBO.SP_change_primary_role" ,""DBO.SP_change_secondary_role", "DBO.SP_change_monitor_role" so how can i run this scripts... so any body know this how to change standby to primary ? please tell me........

Thanks,

Nageswar.

You can execute following query to change secondary db to primary in case of fail over,

RESTORE LOG [SecondaryDB] WITH RECOVERY