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

  • January 29, 2015 at 2:20 pm

    #1774184

    Perry Whittle (1/29/2015)

    Calvin Duffy (1/29/2015)

    No full backup was taken after the mirroring broke.

    If a full backup has occurred on the principal since mirroring broke you're stuck with re iinitializing mirroring unless you can find all the log backups and apply them in sequence

    Calvin Duffy (1/29/2015)

    Making a backup and restoring from DR does not work.

    That's good because that's not what I suggested 😉

    Once you put the DR database online, how are you going to re-establish the mirroring again without re-copying Full backup from production ?. Are you assuming the last full backup is already copied to DR site ?. If not, there is no Diff or TRN backup will help you to re-establish the mirroring again period.