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.
Showing posts with label logshippin. Show all posts
Showing posts with label logshippin. Show all posts
Sunday, February 19, 2012
Subscribe to:
Posts (Atom)