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.
What mirroring mode are you using?
What status is your principal/mirror in? check this by looking at the
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