Results 1 to 3 of 3
  1. #1
    Join Date
    May 2007
    Posts
    6

    Red face Unanswered: How to bring existing Database in standy mode of secondary server for logshipping

    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.Hassan

  2. #2
    Join Date
    Mar 2007
    Location
    Holmestrand, Norway
    Posts
    332
    My guess would be:

    RESTORE DATABASE dbName WITH STANDBY
    Ole Kristian Velstadbråten Bangås - Virinco - MSSQL.no - Facebook - Twitter

  3. #3
    Join Date
    May 2007
    Posts
    6
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •