SQL Server Performance

Recover Mirror Database from Snapshot Database

Discussion in 'SQL Server 2005 Database Mirroring' started by dineshasanka, Feb 28, 2008.

  1. dineshasanka Moderator

    I have a mirred database and have snapshot created from the mirroed database. I can do data selecting from the snapshot. But when the pricipal server is down , I can re-active the mirroed database.( I did succesfully upto this). Then I need to restore the database from snapshot and which failing with following error message.
    Msg 5123, Level 16, State 1, Line 3 CREATE FILE encountered operating system error 3(error not found) while attempting to open or create the physical file 'E:sql_datadevitst_mirrorlog st_mirror_log.ldf'. Msg 5024, Level 16, State 2, Line 3
    No entry found for the primary log file in sysfiles1.
    Could not rebuild the log. Msg 5028, Level 16, State 2, Line 3
    The system could not activate enough of the database to rebuild the log.
    Msg 3013, Level 16, State 1, Line 3 RESTORE DATABASE is terminating abnormally.
  2. dineshasanka Moderator

    No answer even from the MSDN forum. So I think it is better to post this at connect.microsoft.com
  3. satya Moderator

    Interesting, have you looked at the counters and other warning messages on the log.

Share This Page