asked
Database Suspect
Hello All, One of our production database went in suspect mode. It is sql 2008 and the database is replicated(merge replication) I found following errors in the log. SQL Server Assertion: File: , line=3051 Failed Assertion = 'GetGhostRecCount () > 0'. 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. Rollback encountered a page with a log sequence number (LSN) less than the original log record LSN. Could not undo log record (70137:2274:71), for transaction ID (0:25516182), on page (1:1445024), database '' (database ID 13). Page information: LSN = (70137:2274:70), type = 1. Log information: OpCode = 3, context 1. Restore or repair the database. Stack Signature for the dump is 0x10521621 2013-02-07 12:25:56.23 spid22s External dump process return code 0x20000001. External dump process returned no errors. During undoing of a logged operation in database '', an error occurred at log record ID (70137:2274:71). Typically, the specific failure is logged previously as an error in the Windows Event Log service. Restore the database or file from a backup, or repair the database. Database '' was shutdown due to error 3448 in routine 'XdesRMReadWrite::RollbackToLsn'. Restart for non-snapshot databases will be attempted after all connections to the database are aborted. The log for database '' is not available. Check the event log for related error messages. Resolve any errors and restart the database Please help in solving this
Can you see the entry in the Windows Event Log that this message mentions? If so, can you post the details into your question please?
The error in windows event log is Rollback encountered a page with a log sequence number (LSN) less than the original log record LSN. Could not undo log record (70137:2274:71), for transaction ID (0:25516182), on page (1:1445024), database '' (database ID 13). Page information: LSN = (70137:2274:70), type = 1. Log information: OpCode = 3, context 1. Restore or repair the database. During undoing of a logged operation in database '', an error occurred at log record ID (70137:2274:71). Typically, the specific failure is logged previously as an error in the Windows Event Log service. Restore the database or file from a backup, or repair the database. The log for database '' is not available. Check the event log for related error messages. Resolve any errors and restart the database.
Remember, if an answer to your question is helpful, vote it up by clicking on the thumbs up symbol next to it. If the answer solves your problem, be sure to click the check box next it to identify it as the solution. Do this for all your questions.
15 People are following this question.
