can't synchronized db mirror

Question

can help me....i have db mirror..but when network is loss or disconnect, db mirror can't synchronized automatic when network is conected, but i can try ping dns is resolved...i use (principall no witness) sql server 2008 enterprise 64 and windows server 2008 R2 enterprise 64

Answer 1

Hi Sunawan,

What is the state of the database mirroring? You may have a try to suspend and resume the mirroring:

ALTER DATABASE <db_name> SET PARTNER SUSPEND
GO
WAITFOR DELAY '00:05'
GO
ALTER DATABASE <db_name> SET PARTNER RESUME
GO

---

Stephanie Lv

TechNet Community Support

Answer 2

Yes,I agree with Stephanie here.You would need to check the status of mirroring - 

SELECT (SELECT DB_NAME(7)AS DBName),
database_id,
mirroring_state_desc,
mirroring_role_desc,
mirroring_partner_name,
mirroring_partner_instance
FROM sys.database_mirroring
WHERE database_id=7  --Replace this

Mostly the state will be suspended and you should resume it.

---

Anup | Database Consultant

Blog: www.sqlsailor.com Twitter: Follow me !

Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Answer 3

The interesting question is: Why doesn't it pick up automatically after the network loss? I have run DB Mirroring for 7 years now, and it almost always picked up automatically after a network glitch. Can you check your SQL Error Log and post us the messages it gives when the mirror gets disconnected?

Lucifer

Answer 4

Absolutely Mr. PrinceLucifer.. I have the using the DB Mirroring since 3 years. Its automatically ping to network connection and will automatically synchronize the database..

---

Sivamanikanta. P

Answer 5

The interesting question is: Why doesn't it pick up automatically after the network loss? I have run DB Mirroring for 7 years now, and it almost always picked up automatically after a network glitch. Can you check your SQL Error Log and post us the messages it gives when the mirror gets disconnected?

Lucifer

so....when db mirror is down....can't UP otomatis, i try restart service SQL but can't up....but when i restart server ( principall n mirror) db can up. why ??? data size 100GB and connection network 1Mb. thanks a lot :)

Answer 6

Please check the SQL Error Log when you see the problem again. I can think of a lot of reasons that could lead to this, but they are all highly hypothetical...

Answer 7

can you able to telnet on to mirroring endports on bi-directional (check with sysadmin any one closed the ports in firewall)? as PriceLucifer suggested check SQL Error log when it re-appers

---

http://uk.linkedin.com/in/ramjaddu