Post reply

Creating Snapshot From Mirror Database Failed - Could not redo log record

  • September 1, 2015 at 8:17 am

    #320268

    Hi,

    Process to create snapshot failed (twice per day snapshot of the database is being created for some people to work on). Morning snapshot worked fine but the afternoon one failed. The snapshot is being created from Mirror database. I used this code:

    CREATE DATABASE [DB_snapshot] ON

    (name = N'DB',filename = N'D:\Snapshot\DB.SQLSnapshot' )

    ,(name = N'indexes',filename = N'D:\Snapshot\DB_indexes.SQLSnapshot' )

    AS SNAPSHOT OF DB

    and the error message i get

    Msg 1823, Level 16, State 6, Line 1

    A database snapshot cannot be created because it failed to start.

    Msg 1823, Level 16, State 7, Line 1

    A database snapshot cannot be created because it failed to start.

    Msg 3456, Level 21, State 1, Line 1

    Could not redo log record (202011:19306:2), for transaction ID (0:0), on page (1:1823948), allocation unit 281474979397632, database 'DB_snapshot' (database ID 6). Page: LSN = (201954:220201:1), allocation unit = 281474979397632, type = 1. Log: OpCode = 4, context 18, PrevPageLSN: (202010:23679:1). Restore from a backup of the database, or repair the database.

    Msg 3313, Level 21, State 1, Line 1

    During redoing of a logged operation in database 'DB_snapshot', an error occurred at log record ID (202011:19306:2). Typically, the specific failure is previously logged as an error in the Windows Event Log service. Restore the database from a full backup, or repair the database.

    What might be causing this error? Mirroring seems to be working OK. status is "Synchronized"

  • September 2, 2015 at 2:05 am

    #1823888

    Ok, looks like problem is solved.

    We are using asynchronous mirroring and the secondary was falling behind. There was some other process on the secondary that was taking IO for some time and caused log transfers to queue.

    DATABASE_MIRRORING log reuse wait on the principal gave me the idea that this might be the problem.

    Anyways... all started working when other process taking IO finished it's work and logs were transferred.

Viewing 2 posts - 1 through 1 (of 1 total)

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