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.
Sunday, February 19, 2012
How to bring existing Database in standy mode of secondary server for logshippin
Labels:
database,
existing,
logshippin,
logshipping,
microsoft,
mode,
mysql,
oracle,
primaryserver,
secondary,
secondaryserver,
server,
sql,
sqlserver2000,
standy
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment