title: Snapshot of the mirrored database fails due to log issue
body: <p>We have server A hosting principal database and server B hosting its mirror. To minimize the workload caused by reporting we are creating daily snapshot of the mirror database on Server B. For years we were running the same job and it was working fine. </p>
  
  <p>The code we use first deletes the old snapshot (this still works) and then creates the brand new one using the query:</p>
  
  <pre><code>create database [DB_snapshot] on 
     (name = N'rsdev3',filename = N'd:\snapshot\DB.sqlsnapshot' ) ,
     (name = N'indexes',filename = N'd:\snapshot\DB_indexes.sqlsnapshot' ) 
  as snapshot of DB
  </code></pre>
  
  <p>The above code worked fine so far, but today for the first time we got the following error:</p>
  
  <p>Error message</p>
  
  <blockquote>
    <p>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.</p>
  </blockquote>
  
  <p>I goggled it, but nothing helpful came up. I am afraid that I may end up disconnecting and then connecting again the mirroring, but I would prefer to avoid doing it because it would be very inconvenient right now. </p>
  
  <p>Have you ever experience something similar? Do you have any ideas how to fix this? I will be very grateful for any tips and advices!</p>