3

When pricipal database is having less changes than mirror database i.e mirror_failover_lsn is greater than mirror_end_of_log_lsn of principal server, the mirroring session got suspended nad couldn't get resumed. Why so? . Now how can I restore my database and how to establish the session again?

migrated from stackoverflow.com Feb 26 '10 at 16:09

This question came from our site for professional and enthusiast programmers.

1

What mirroring mode are you using?

Are you saying that you have writeable access to both databases in the mirror? If so you may be affected by one of these bugs: 978947,978791

What status is your principal/mirror in? check this by looking at the sys.database_mirroring DMV on each server.

0

You could try one of these options:

May work - Pause/suspend mirroring - Backup database and logs and copy backups to mirror - Restore backups and logs with NORECOVERY - Try and resume mirroring

Will work - Remove mirroring - Restore latest backup and log files to mirror - Re-run mirroring setup

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.