Initial Restore for Mirroring stuck "Restoring..."

  • Hello,

    I am attempting to set up database mirroring on a new, empty database. I did a full backup and then a transaction log backup on the principal database.

    I did a restore on the server which will hold the mirror database with the backup file. It says it restored, but the database is stuck "Restoring...".

    I've tried doing the restore with the database already existing and with it being created in the restore process. I am using NORECOVERY.

    What could I be doing wrong here?

    Thank you!

    Christine

  • The mirror database should be in the restoring status. It is in that state so that new logs can be applied to the database.

  • NORECOVERY means restore this and leave the database in a restoring state

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Wow - don't I feel dumb. Thanks so much!

    I'm still having issues setting up mirroring, but I guess I should start another post with the appropriate title. Thanks again!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply