Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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?

share|improve this question

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

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

2 Answers 2

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.

share|improve this answer

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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