Sunday, February 19, 2012

How to bring existing Database in standy mode of secondary server for logshippin

Hi,

I am doing a logshipping in sqlserver2000.
I have PrimaryServer database A and Secondaryserver A which is already existing. Now if i am trying to establish logshipping with this existing db in secondaryserver it says db A in destination is not in standy mode.

Please help me how to bring the db in standy mode that can be used to do logshipping.

Thanks
Md S.HassanMy guess would be:

RESTORE DATABASE dbName WITH STANDBY|||Hi Roa

I am getting this error message after trying with your suggestion

Server: Msg 155, Level 15, State 1, Line 1
'STANDBY' is not a recognized RESTORE option.

No comments:

Post a Comment