Showing posts with label logshippin. Show all posts
Showing posts with label logshippin. Show all posts

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.