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 |
|
nickgreenery
Starting Member
2 Posts |
 Posted - 2008-08-07 : 09:30:00
|
| We have been using mirroring in production for a while now. This problem though is the most puzzling. Every couple days the mirror will go down on a few databases. Specifically the principal will go disconnected and then recover the mirror very quickly (with in a minute or two). This happens at random times on random databases. Other databases remain unaffected. We have replaced all network hardware and the problem persists. We also ran pings from all 3 mirrored servers to all 3 mirrored servers. When the mirror disappears for certain databases we noticed the pings worked fine, there was not a single packet dropped. Since no pings were dropped we do not believe it is a network issue, but that it is a sql server issue.Why is the mirror database disappearing for certain databases at random times?Any thoughts would be appreciated, Thank in advance. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-07 : 13:19:19
|
| What do you see with this DMV(sys.dm_db_mirroring_connections).? Check the status. Looks like connection issue.You can increase your Connection timeout for DB mirroring with:ALter database yourdatabase set Partner Timout yourdesiredsec. |
 |
|
|
|
|
|
Mirror disappearing