Database Consistency errors | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Database Consistency errors

Hi, I have an active-active SQL cluster server. The 1st node contains only one (user) database.
The second node has a replicated database of this one (transactional replication).
Yesterday I found a consistency errors in the database on the 1st node. I fixed it db with dbcc checkdb…
Then I created a new snapshot snd configured again the transactional repl. (The second node is the distributor.) I have a 3rd database on the2nd node that gets data from the replicated db. (triggers and stored procedures are responsibel for this on the 2nd node) I found some error messages in the application log that the every databases contains errors on the second node (including distribution database) when I use the dbcc checkdb it founds no errors in the database. It is very strange for me. Do you have any suggestion why happend this or what is the solution? Thanks Zsolt
What are those ‘some error messages’ found in application log, post them to assess? _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

The msg is the following<br /><br />Error: 8908, Severity: 22, State: 6<br />Table error: Database ID 9, object ID 1333631844, index ID 0. Chain linkage mismatch. (1:707634)-&gt;next = (1:24354), but (1:24354)-&gt<img src=’/community/emoticons/emotion-4.gif’ alt=’;p’ />rev = (1:24353). <br /><br />if I run the dbcc dbcheck on the appropriate db it dosen’t found any error.<br /><br />Zsolt
What is the level of service pack on SQL & OS? _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

W2K SP4 and SQL2K Sp3 Zsolt
To ensure that the database is free of corruption, run a DBCC CHECKDB statement, preferably in single user mode, against the database. If DBCC CHECKDB returns no error, you can be certain that the database is free of corruption. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

do xou know what is the cause of this problem?<br />currently my replicated database is corrupted again. If I run the dbcc checkdb with repair_rebuild solves the problem.<br /><br />Several hours later the problem occures again<br /><br />I got the following message:<br /><br /><br />Error: 8908, Severity: 22, State: 6<br />Table error: Database ID 9, object ID 1333631844, index ID 0. Chain linkage mismatch. (1:24544)-&gt;next = (1:618432), but (1:618432)-&gt<img src=’/community/emoticons/emotion-4.gif’ alt=’;p’ />rev = (1:765054). <br /><br /><br />Zsolt
You must check from event viewer and see any h/w issues or any drive issues that might triggering this consistency error. Its better to run DBCC checks and backup the database and restore on replicated end. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

]]>