Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003

    Unanswered: Bringing Standby server online when in "no recovery mode"


    I am trying to set up Log Shipping. Though I have the following problem...
    I want to set up LS without any user being able to connect. As I understand, this means I have to select the "No recovery mode" in the "Add Destination Database" window when creating the Log Shipping Maintenance Plan.
    This all works fine. I set this up, no user can connect to the database (it shows status: (Loading) ), perfect.

    However, the problem I encounter is when I want to bring the Standby server online.
    I run the 'sp_change_primary_role' SP on the primary server... works fine.
    I run the 'sp_change_secondary_role' on the standby server... errors:

    Server: Msg 927, Level 14, State 2, Line 1
    Database 'Northwind' cannot be opened. It is in the middle of a restore.
    Server: Msg 5069, Level 16, State 1, Line 1
    ALTER DATABASE statement failed.
    Server: Msg 14440, Level 16, State 1, Procedure sp_change_secondary_role, Line 49
    Could not set single user mode.

    So what am I doing wrong? Am I forgetting something? I think i must do. The only way to get the secondary (standby) online is to do a "detach - attach", as far as I know.
    I can not check its Properties or do a restore or backup of this database either.

    Any help would be very much appreciated.

    Thanks in advance and kind regards,

    Jan V.

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 11
    Run the following command, to open the database:

    restore database (name of database) with recovery

    This will trigger a recovery of the database, and reset the database to "open" from "loading"

Posting Permissions

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