Errors shown in DBCC CHECKDB - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Data Corruption Issues

Errors shown in DBCC CHECKDB

Author

Topic

patchw
Starting Member

3 Posts

Posted - 2009-07-22 : 09:41:16

Hi All,

I have just inherited a database with a new job, Ran dbcc checkdb over the main database with the following results. Any advice on the best way to procede would be great.

Table error: Object ID 2. The text, ntext, or image node at page (1:181940), slot 3, text ID 2128953802752 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1

Server: Msg 2576, Level 16, State 1, Line 1
IAM page (0:0) is pointed to by the previous pointer of IAM page (1:1698624) object ID 1004582667 index ID 2 but was not detected in the scan.

CHECKDB found 2 allocation errors and 120 consistency errors in database 'Phoenix'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (Phoenix ).

Thanks

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2009-07-22 : 11:35:17

Ok, these aren't too serious.

When you have some downtime, take the database into single user mode and run CheckDB with the repair_allow_data_loss option. The first error is the one requiring that repair level. There's a text page that is not referenced by any row in the table. It can be as a result of a previous repair run on the table. In this particular case, running checkDB with the repair_allow_data_loss option will not lose data. The text page is already orphaned and is already lost.

The second error is in a nonclustered index, so SQL will just rebuild it during the repair.

For some general advice on corruption, take a look at this article. [url]http://www.sqlservercentral.com/articles/65804/[/url]

--
Gail Shaw
SQL Server MVP

patchw
Starting Member

3 Posts

Posted - 2009-07-22 : 12:08:57

That's great news, thanks for that. Looks like I'm back into the office at 10 tonight then.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2009-07-23 : 04:32:57

Hang on. Just noticed that second last line indicates 120 consistency errors. That wasn't the full output of CheckDB that you posted?
Can you post the full output? There may be an error in the others that changes the recommended approach/

--
Gail Shaw
SQL Server MVP

patchw
Starting Member

3 Posts

Posted - 2009-07-23 : 06:37:44

Below is the complete list of errors. I only posted the one as to my limited knowledge as they all had server msg 8964 they would have the same fix. I did run the repair last night after taking a backup and it completed and now reports no errors so hopfully I have done no damage and the system is being used in anger at the moment with no reported problems. Thanks for taking a second look.

Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:23), slot 7, text ID 1291136466944 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:23), slot 8, text ID 1291136532480 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:109), slot 77, text ID 900278714368 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:668), slot 19, text ID 2192945840128 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:669), slot 2, text ID 2387543261184 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:824), slot 2, text ID 1069729775616 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:824), slot 10, text ID 1069729841152 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:885), slot 0, text ID 2192945905664 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:886), slot 17, text ID 1202806849536 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:1441), slot 5, text ID 1115075510272 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:1441), slot 6, text ID 1115075575808 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:1445), slot 7, text ID 1032359444480 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:1445), slot 9, text ID 1032359510016 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:1445), slot 11, text ID 1048899682304 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:1445), slot 13, text ID 1048899747840 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:3266), slot 6, text ID 2073822429184 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:3266), slot 8, text ID 2073822494720 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:3267), slot 3, text ID 966701940736 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:3270), slot 1, text ID 1327174057984 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:3270), slot 2, text ID 1327174123520 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:3270), slot 3, text ID 1912616714240 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:3270), slot 4, text ID 1912616779776 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:43737), slot 2, text ID 2045100425216 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:43737), slot 17, text ID 2045100490752 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:44426), slot 6, text ID 1202806915072 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:44427), slot 3, text ID 966702006272 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:44427), slot 4, text ID 1003006328832 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:44427), slot 6, text ID 1003006394368 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:44428), slot 12, text ID 878852374528 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:45809), slot 8, text ID 1355978375168 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:45809), slot 9, text ID 1355978440704 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:52984), slot 10, text ID 2097759846400 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:52984), slot 12, text ID 2097759911936 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:52984), slot 17, text ID 2387543195648 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:52991), slot 1, text ID 878852440064 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:73048), slot 5, text ID 812779962368 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:73048), slot 7, text ID 900278648832 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:73050), slot 2, text ID 812779896832 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:77490), slot 13, text ID 2493137223680 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:77490), slot 14, text ID 2493137289216 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:77491), slot 5, text ID 2337389215744 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:77495), slot 6, text ID 2634302291968 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:77495), slot 7, text ID 2634302357504 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:181940), slot 3, text ID 2128953802752 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:181940), slot 5, text ID 2128953868288 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:241540), slot 21, text ID 1954040250368 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:241540), slot 22, text ID 1954040315904 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:365193), slot 2, text ID 1147367981056 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:365193), slot 5, text ID 1147368046592 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:459912), slot 10, text ID 2435611754496 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:461929), slot 3, text ID 1586853445632 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:461929), slot 4, text ID 1586853511168 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:461929), slot 6, text ID 1664233897984 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:461929), slot 7, text ID 1664233963520 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:461929), slot 9, text ID 1723805466624 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:461929), slot 10, text ID 1723805532160 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:478600), slot 7, text ID 2699098587136 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:478600), slot 8, text ID 2699098652672 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:501657), slot 2, text ID 2240187006976 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:501657), slot 3, text ID 2240187072512 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:553976), slot 3, text ID 1526340059136 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:553976), slot 4, text ID 1526340124672 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:556825), slot 2, text ID 1147515830272 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:556825), slot 3, text ID 1147515895808 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:556825), slot 5, text ID 1187492724736 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:556825), slot 13, text ID 1187492790272 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:608224), slot 2, text ID 2273917075456 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:622210), slot 2, text ID 1263490498560 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:622210), slot 4, text ID 1263490564096 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:622212), slot 10, text ID 2672056598528 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:622212), slot 11, text ID 2672056664064 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:681240), slot 2, text ID 1781735424000 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:681240), slot 6, text ID 2534547718144 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:681240), slot 7, text ID 1781735489536 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:681240), slot 8, text ID 2534547783680 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:683853), slot 17, text ID 1215799623680 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:683853), slot 18, text ID 1215799689216 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:729600), slot 2, text ID 948296220672 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:729600), slot 4, text ID 948296286208 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:758787), slot 2, text ID 1414153961472 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:758787), slot 4, text ID 1414154027008 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:758787), slot 6, text ID 1460348583936 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:758787), slot 7, text ID 1460348649472 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:758787), slot 9, text ID 2413837156352 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:758787), slot 10, text ID 2413837221888 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:801083), slot 4, text ID 845006241792 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:801083), slot 6, text ID 845006307328 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:801083), slot 8, text ID 2337389281280 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:897208), slot 1, text ID 2435611820032 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:1418056), slot 2, text ID 1232506912768 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:1418056), slot 3, text ID 1232506978304 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:1685913), slot 2, text ID 766377394176 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:1685913), slot 4, text ID 766377459712 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:1685913), slot 6, text ID 785358192640 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:1685913), slot 8, text ID 785358258176 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:1725904), slot 2, text ID 1821437591552 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:1725904), slot 4, text ID 1821437657088 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:1725904), slot 6, text ID 1853847175168 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:1725904), slot 7, text ID 1853847240704 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:1759609), slot 2, text ID 2300785983488 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:1848413), slot 3, text ID 2364901359616 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:1848413), slot 4, text ID 2364901425152 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2009888), slot 2, text ID 2300786049024 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2038072), slot 2, text ID 1764762910720 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2038072), slot 4, text ID 1764762976256 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2230648), slot 5, text ID 1990474203136 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2230648), slot 6, text ID 1990474268672 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2230648), slot 8, text ID 2000666558464 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2230648), slot 9, text ID 2000666624000 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2230648), slot 11, text ID 2018642296832 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2230648), slot 12, text ID 2018642362368 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2248135), slot 4, text ID 2561497628672 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2248135), slot 5, text ID 2561497694208 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2373737), slot 2, text ID 2164621705216 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2373737), slot 4, text ID 2164621770752 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2373742), slot 2, text ID 2583945609216 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2373742), slot 7, text ID 2583945674752 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2934746), slot 1, text ID 2273917140992 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:3077160), slot 2, text ID 2605173506048 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:3077160), slot 3, text ID 2605173571584 is not referenced.
There are 3268 rows in 153 pages for object 'sysindexes'.
CHECKDB found 0 allocation errors and 120 consistency errors in table 'sysindexes' (object ID 2).

DBCC results for 'HRI03_Main'.
Server: Msg 2576, Level 16, State 1, Line 1
IAM page (0:0) is pointed to by the previous pointer of IAM page (1:1698624) object ID 1004582667 index ID 2 but was not detected in the scan.
Server: Msg 2576, Level 16, State 1, Line 1
IAM page (0:0) is pointed to by the previous pointer of IAM page (1:1698625) object ID 1004582667 index ID 3 but was not detected in the scan.
There are 106566 rows in 3493 pages for object 'HRI03_Main'.

CHECKDB found 2 allocation errors and 120 consistency errors in database 'Phoenix'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (Phoenix ).

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2009-07-23 : 12:14:59

Yeah, that's fine.
Sometimes people leave out what they think are 'harmless' errors and in fact they're the worse than the ones they did post.

Something sometime has really done some damage to sysindexes there. You're very lucky, schema corruption is usually not repairable. Don't suppose you have any idea when these errors started? It would be useful to check and see if there are any hardware errors that correspond to the time the errors started.

btw, is this SQL 2000 or SQL 2005?
Edit: Nevermind, it's SQL 2000.

Can you run a CheckCatalog when you have some downtime? It's not included in CheckDB in SQL 2000, has to be run separately.

DBCC CHECKCATALOG (< Database Name > )

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources