Post reply

Initial Restore for Mirroring stuck "Restoring..."

  • July 17, 2009 at 10:30 am

    #212326

    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

  • July 17, 2009 at 11:04 am

    #1026334

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

  • July 17, 2009 at 11:26 am

    #1026348

    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

  • July 17, 2009 at 11:49 am

    #1026361

    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