Home Forums SQL Server 2012 SQL 2012 - General Re-establish mirroring after DR test RE: Re-establish mirroring after DR test

  • January 27, 2015 at 2:24 pm

    #1773516

    5. Restore the DB from the snapshot with recovery (not sure if this is even possible)

    You can restore the database from snapshot with recovery only. Although you can include the statement "NORECOVERY" and it will not error out, it will still restore it with recovery.

    6. Restore log backups from the primary side

    You can not do that anymore since the database on the step 5 restored with RECOVERY.

    Thanks for that follow up. I was just noticing that messing around here. I didn't think that a snapshot touched LSN's so that is pretty much confirmed.