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?
2 Answers
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