31 ianuarie 2012 00:31
How do we re-attach the mirror to its principal after it's been detached for a while ?
Originally the mirror was restoring successfully. We broke the mirror manually, left it for a few days.
Now we want to put the mirror back in place but without re-creating the mirror by restoring the latest backup of principal datafile and log .
Is it possible to do it ?
31 ianuarie 2012 01:33
Once you break the mirror SQL does not send or store the log records that are required to be sent from the principal to the mirror. Therefore the mirror cannot re-sync with the principal using the logs as they no longer exist. In theory if you had all the log backups you could roll the mirror forward to the current time however depending on how long it has been this is normally more hassle than it is worth.
If you did not break the mirror and were not syncing for a long period of time the transaction log on the principal would continue to grow larger as the log backups would not be able to recycle and wrap around the log as SQL would be locking those entries waiting to send them to the mirror.
31 ianuarie 2012 08:14Sean has a point... What you need to do is roll forward the DB using all transaction log backups that were taken since the mirror disconnect. If you can achieve this you can reestablish the mirror. Otherwise there is no way to do it unfortunately.
31 ianuarie 2012 09:23You must replay all log backups on mirroring since then before re-establish mirroing other wise you must recrease mirroring from scratch
- Marcat ca răspuns de quanongsql 3 februarie 2012 02:45