SQL SERVER 2008 R2 Mirror problem
Hi I am testing SQL server 2008 R2 with databases in mirror with witness.
When I am doing tests in which i am turning off and the sql servers and the databses are failing over. About 90 % of these tests are successfull, but sometimes some databses stay in status mirroring/suspended and principal/suspended and they DONT RECOVER BACK.
When I try to manual resume via SQL MANAGMENT STUDIO the mirror I get error
SQL Server Assertion: File: <loglock.cpp>, line=796 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.
Database mirroring will be suspended. Server instance [SQL SERVER NAME] encountered error 3624, state 1, severity 20 when it was acting as a mirroring partner for database '[databasename]'. The database mirroring partners might try to recover automatically from the error and resume the mirroring session. For more information, view the error log for additional error messages.
Happens this error or similar erorrs when failing to another server in SQL 2008 R2 Mirror architecture a lot or how can I solve this error ?
When I am doing tests in which i am turning off and the sql servers and the databses are failing over. About 90 % of these tests are successfull, but sometimes some databses stay in status mirroring/suspended and principal/suspended and they DONT RECOVER BACK.
When I try to manual resume via SQL MANAGMENT STUDIO the mirror I get error
SQL Server Assertion: File: <loglock.cpp>, line=796 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.
Database mirroring will be suspended. Server instance [SQL SERVER NAME] encountered error 3624, state 1, severity 20 when it was acting as a mirroring partner for database '[databasename]'. The database mirroring partners might try to recover automatically from the error and resume the mirroring session. For more information, view the error log for additional error messages.
Happens this error or similar erorrs when failing to another server in SQL 2008 R2 Mirror architecture a lot or how can I solve this error ?
Rob Farley
If you're turning off servers, are you causing disk corruption? I would recommend that when you try to get a server back after it's gone down, you run a DBCC CHECKDB to look for corruption on the disk. Then you can more comfortably reintroduce it into the mirroring scenario.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.