Database mirroring is suspended

Question

Database mirroring for one of the database is suspended, when I try to resume it again suspends. I have checked the SQL log in the Mirror server. I could also see some stack dump messages in sql log. Is this a bug ? This has been working for last 8 months without issues.

Env: SQL 2005 SP2+Hotfix (9.00.3159) 64 Bit EE

Excerpts from SQL Log:

While acting as a mirroring partner for database 'MOSS_SSP_SG-PROD-MOSS_StandardSSP1_Search', server instance 'SINSHPDBP3701' encountered error 3624, status 1, severity 20. Database mirroring will be suspended.  Try to resolve the error and resume mirroring.

A system assertion check has failed. Check the SQL Server error log for details. Typically, an assertion failure is caused by a software bug or data corruption. To check for database corruption, consider running DBCC CHECKDB. If you agreed to send dumps to Microsoft during setup, a mini dump will be sent to Microsoft. An update might be available from Microsoft in the latest Service Pack or in a QFE from Technical Support.

SQL Server Assertion: File: <loglock.cpp>, line=818 Failed Assertion = 'result == LCK_OK'. This error may be timing-related. If the error persists after rerunning the statement, use DBCC CHECKDB to check the database for structural integrity, or restart the server to ensure in-memory data structures are not corrupted.

Answer 1

I found an article on this error , please try this link http://forum.lessthandot.com/viewtopic.php?f=22&t=7540

---

Thanks, Leks