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?
Asked
Active
Viewed 188 times
2 Answers
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.
Nick Kavadias
- 10,796
- 7
- 37
- 47
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
Jason Cumberland
- 1,579
- 10
- 13