Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chanduraag
Starting Member
14 Posts |
 Posted - 2012-09-14 : 10:11:58
|
| hi sql teamwe have mirroring setup. suddenly mirror db gone out of sink with the primary. client needs the exactly at what time it was gone out of sink plz help me how to know this onethank you for your support |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-09-14 : 10:34:34
|
| Is it just not in "synchronized" status? Or is it "disconnected" or "suspended"?If mirroring actually broke, check the SQL Server error logs, filter by "mirror" and you should find messages showing when the mirror broke.Did you have a witness set up? Did the mirror fail over, or just did it just stop?Did you set up mirror monitoring? If you ran sp_dbmmonitoraddmonitoring then you can run sp_dbmmonitorresults and check the synchronization status and pinpoint out-of-sync more easily. You can also add alerts in SQL Agent to notify you when mirror status changes. |
 |
|
|
chanduraag
Starting Member
14 Posts |
Posted - 2012-09-14 : 10:58:02
|
| thanks a lot |
|
|
|
|
|
|
how to know the time when the mirroring is failed