Home All Groups Group Topic Archive Search About

General SQL Error

microsoft.public.sqlserver.programming
Author
11 Feb 2006 11:50 AM
Islamegy®
When i try to open programs which my database it give this error.. so i
tried to run
DBCC CHECKDB and here is the result but i'm unable to repair it with
REPAIR_ALLOW_DATA_LOSS  or REPAIR_REBUILD
so how could i repair my database??

Below is a part of the excution result but the group server don't allow me
to send the whole error..
I may send it by mail to anyone intersting to help me
thanx
----------------------------------------------
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -2143188841, index ID 0, page ID (3:969). The PageId
in the page header = (4:2097196).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -2143188841, index ID 0, page ID (3:1002). The PageId
in the page header = (8:1572908).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -2143188841, index ID 0, page ID (3:1185). The PageId
in the page header = (14:1572908).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -2113043956, index ID 33283, page ID (3:6095). The
PageId in the page header = (33298:-2112781808).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -1996486771, index ID 65535, page ID (3:6467). The
PageId in the page header = (1060:1552485445).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -1995680373, index ID 1060, page ID (3:6475). The
PageId in the page header = (9340:-1979711565).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -1983249921, index ID 59573, page ID (3:6464). The
PageId in the page header = (65535:-125572609).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -1980235758, index ID 1033, page ID (3:6545). The
PageId in the page header = (1033:1770505).
CHECKDB found 0 allocation errors and 3 consistency errors in table '(Object
ID -2143188841)' (object ID -2143188841).
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object
ID -2113043956)' (object ID -2113043956).
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object
ID -1996486771)' (object ID -1996486771).
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object
ID -1995680373)' (object ID -1995680373).
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object
ID -1983249921)' (object ID -1983249921).
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object
ID -1980235758)' (object ID -1980235758).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -1962934272, index ID 7204, page ID (3:6513). The
PageId in the page header = (53761:1784).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -1873442348, index ID 46607, page ID (3:6517). The
PageId in the page header = (55381:-1919924855).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -1844604404, index ID 37379, page ID (3:6096). The
PageId in the page header = (37394:-1844342256).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -1806302640, index ID 0, page ID (3:1077). The PageId
in the page header = (11495:-140203890).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -1775632384, index ID 0, page ID (3:6315). The PageId
in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -1606079722, index ID 65535, page ID (3:6514). The
PageId in the page header = (14205:-168).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -1576164852, index ID 41475, page ID (3:6097). The
PageId in the page header = (41490:-1575902704).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -1465024753, index ID 61545, page ID (3:6489). The
PageId in the page header = (65535:-894388865).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -1307725300, index ID 45571, page ID (3:6098). The
PageId in the page header = (45586:-1307463152).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -1243779476, index ID 0, page ID (3:1256). The PageId
in the page header = (11486:-1243779476).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -1242689680, index ID 0, page ID (3:1034). The PageId
in the page header = (11659:911220612).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -1240526836, index ID 28431, page ID (3:6470). The
PageId in the page header = (4108:-202324724).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -1152210384, index ID 0, page ID (3:1082). The PageId
in the page header = (0:268595332).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -1039285748, index ID 49667, page ID (3:6099). The
PageId in the page header = (49682:-1039023600).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -973271089, index ID 60175, page ID (3:6488). The
PageId in the page header = (6460:-1240465409).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -973043694, index ID 768, page ID (3:6249). The
PageId in the page header = (35131:-67074006).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -964489724, index ID 9844, page ID (3:6490). The
PageId in the page header = (40331:408259567).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -952557369, index ID 55433, page ID (3:6448). The
PageId in the page header = (49153:609061656).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -922677171, index ID 33745, page ID (3:6498). The
PageId in the page header = (0:69485767).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -805371899, index ID 44103, page ID (3:6850). The
PageId in the page header = (5:-571998203).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -764276784, index ID 49511, page ID (3:6471). The
PageId in the page header = (53362:266005263).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -757274380, index ID 1, page ID (3:6680). The PageId
in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -664137952, index ID 24847, page ID (3:6466). The
PageId in the page header = (63343:254302335).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -651129463, index ID 59573, page ID (3:6477). The
PageId in the page header = (46733:-9928).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -602944036, index ID 64527, page ID (3:6465). The
PageId in the page header = (53244:265738255).
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID -469760349, index ID 14592, page (1700:1140852387).
Test (PageType == WF_PAGE && dbId == TEMPDBID) failed. Values are 24 and 2.
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -451946649, index ID 28431, page ID (3:6442). The
PageId in the page header = (3848:-1202422001).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -360463723, index ID 45449, page ID (3:6521). The
PageId in the page header = (35072:53377).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -318903809, index ID 35592, page ID (3:6520). The
PageId in the page header = (31186:-2072480510).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -254999299, index ID 10751, page ID (3:6473). The
PageId in the page header = (4088:1863305327).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -190291108, index ID 0, page ID (3:1189). The PageId
in the page header = (11478:-190291108).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -141766390, index ID 0, page ID (3:1349). The PageId
in the page header = (11495:-141766390).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -134217730, index ID 55543, page ID (3:6508). The
PageId in the page header = (20969:-654835713).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -65259032, index ID 29704, page ID (3:6523). The
PageId in the page header = (15448:-1958723189).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -49287057, index ID 3841, page ID (3:6450). The
PageId in the page header = (28943:98791695).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -3041115, index ID 4033, page ID (3:6469). The PageId
in the page header = (55136:264792335).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -966656, index ID 1, page ID (3:6218). The PageId in
the page header = (0:12).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -61291, index ID 65535, page ID (3:6512). The PageId
in the page header = (35323:-140914551).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -19470, index ID 7325, page ID (3:6472). The PageId
in the page header = (46607:269284336).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -13896, index ID 65280, page ID (3:6479). The PageId
in the page header = (258:-4063233).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -3002, index ID 7, page ID (3:6509). The PageId in
the page header = (19851:1856).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -421, index ID 21641, page ID (3:6478). The PageId in
the page header = (0:1300019285).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -1, index ID 0, page ID (3:1086). The PageId in the
page header = (1:4096).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -1, index ID 0, page ID (3:1090). The PageId in the
page header = (0:30).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -1, index ID 0, page ID (3:1273). The PageId in the
page header = (1:4096).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -1, index ID 0, page ID (3:1337). The PageId in the
page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 32768, page ID (3:6722). The PageId in
the page header = (0:-2147483648).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 32833, page ID (3:1271). The PageId in
the page header = (0:152).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 34283, page ID (3:1075). The PageId in
the page header = (0:48).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 34283, page ID (3:1183). The PageId in
the page header = (0:152).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 34283, page ID (3:1216). The PageId in
the page header = (0:152).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 34283, page ID (3:1268). The PageId in
the page header = (0:152).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 65535, page ID (3:943). The PageId in the
page header = (0:268437512).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 65535, page ID (3:1076). The PageId in
the page header = (0:160).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 65535, page ID (3:1208). The PageId in
the page header = (0:160).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (3:926). The PageId in the
page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (3:927). The PageId in the
page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (3:928). The PageId in the
page header = (40:65563).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (3:929). The PageId in the
page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (3:932). The PageId in the
page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (3:933). The PageId in the
page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (3:935). The PageId in the
page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (3:937). The PageId in the
page header = (11:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (3:940). The PageId in the
page header = (0:104).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (3:941). The PageId in the
page header = (0:268435456).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (3:942). The PageId in the
page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (3:961). The PageId in the
page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (3:968). The PageId in the
page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (3:971). The PageId in the
page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (3:974). The PageId in the
page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (3:975). The PageId in the
page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (3:976). The PageId in the
page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (3:987). The PageId in the
page header = (0:268498052).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (3:988). The PageId in the
page header = (552:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (3:989). The PageId in the
page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (3:994). The PageId in the
page header = (288:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (3:996). The PageId in the
page header = (0:1120).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (3:997). The PageId in the
page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (3:1000). The PageId in the
page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (3:1003). The PageId in the
page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (3:1004). The PageId in the
page header = (640:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (3:1006). The PageId in the
page header = (0:0).

Author
11 Feb 2006 12:46 PM
James Wilson
Islamegy® wrote:
Show quote
> When i try to open programs which my database it give this error.. so i
> tried to run
> DBCC CHECKDB and here is the result but i'm unable to repair it with
> REPAIR_ALLOW_DATA_LOSS  or REPAIR_REBUILD
> so how could i repair my database??
>
> Below is a part of the excution result but the group server don't allow me
> to send the whole error..
> I may send it by mail to anyone intersting to help me
> thanx
> ----------------------------------------------
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -2143188841, index ID 0, page ID (3:969). The PageId
> in the page header = (4:2097196).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -2143188841, index ID 0, page ID (3:1002). The PageId
> in the page header = (8:1572908).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -2143188841, index ID 0, page ID (3:1185). The PageId
> in the page header = (14:1572908).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -2113043956, index ID 33283, page ID (3:6095). The
> PageId in the page header = (33298:-2112781808).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -1996486771, index ID 65535, page ID (3:6467). The
> PageId in the page header = (1060:1552485445).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -1995680373, index ID 1060, page ID (3:6475). The
> PageId in the page header = (9340:-1979711565).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -1983249921, index ID 59573, page ID (3:6464). The
> PageId in the page header = (65535:-125572609).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -1980235758, index ID 1033, page ID (3:6545). The
> PageId in the page header = (1033:1770505).
> CHECKDB found 0 allocation errors and 3 consistency errors in table '(Object
> ID -2143188841)' (object ID -2143188841).
> CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object
> ID -2113043956)' (object ID -2113043956).
> CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object
> ID -1996486771)' (object ID -1996486771).
> CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object
> ID -1995680373)' (object ID -1995680373).
> CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object
> ID -1983249921)' (object ID -1983249921).
> CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object
> ID -1980235758)' (object ID -1980235758).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -1962934272, index ID 7204, page ID (3:6513). The
> PageId in the page header = (53761:1784).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -1873442348, index ID 46607, page ID (3:6517). The
> PageId in the page header = (55381:-1919924855).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -1844604404, index ID 37379, page ID (3:6096). The
> PageId in the page header = (37394:-1844342256).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -1806302640, index ID 0, page ID (3:1077). The PageId
> in the page header = (11495:-140203890).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -1775632384, index ID 0, page ID (3:6315). The PageId
> in the page header = (0:0).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -1606079722, index ID 65535, page ID (3:6514). The
> PageId in the page header = (14205:-168).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -1576164852, index ID 41475, page ID (3:6097). The
> PageId in the page header = (41490:-1575902704).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -1465024753, index ID 61545, page ID (3:6489). The
> PageId in the page header = (65535:-894388865).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -1307725300, index ID 45571, page ID (3:6098). The
> PageId in the page header = (45586:-1307463152).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -1243779476, index ID 0, page ID (3:1256). The PageId
> in the page header = (11486:-1243779476).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -1242689680, index ID 0, page ID (3:1034). The PageId
> in the page header = (11659:911220612).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -1240526836, index ID 28431, page ID (3:6470). The
> PageId in the page header = (4108:-202324724).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -1152210384, index ID 0, page ID (3:1082). The PageId
> in the page header = (0:268595332).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -1039285748, index ID 49667, page ID (3:6099). The
> PageId in the page header = (49682:-1039023600).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -973271089, index ID 60175, page ID (3:6488). The
> PageId in the page header = (6460:-1240465409).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -973043694, index ID 768, page ID (3:6249). The
> PageId in the page header = (35131:-67074006).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -964489724, index ID 9844, page ID (3:6490). The
> PageId in the page header = (40331:408259567).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -952557369, index ID 55433, page ID (3:6448). The
> PageId in the page header = (49153:609061656).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -922677171, index ID 33745, page ID (3:6498). The
> PageId in the page header = (0:69485767).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -805371899, index ID 44103, page ID (3:6850). The
> PageId in the page header = (5:-571998203).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -764276784, index ID 49511, page ID (3:6471). The
> PageId in the page header = (53362:266005263).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -757274380, index ID 1, page ID (3:6680). The PageId
> in the page header = (0:0).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -664137952, index ID 24847, page ID (3:6466). The
> PageId in the page header = (63343:254302335).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -651129463, index ID 59573, page ID (3:6477). The
> PageId in the page header = (46733:-9928).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -602944036, index ID 64527, page ID (3:6465). The
> PageId in the page header = (53244:265738255).
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID -469760349, index ID 14592, page (1700:1140852387).
> Test (PageType == WF_PAGE && dbId == TEMPDBID) failed. Values are 24 and 2.
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -451946649, index ID 28431, page ID (3:6442). The
> PageId in the page header = (3848:-1202422001).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -360463723, index ID 45449, page ID (3:6521). The
> PageId in the page header = (35072:53377).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -318903809, index ID 35592, page ID (3:6520). The
> PageId in the page header = (31186:-2072480510).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -254999299, index ID 10751, page ID (3:6473). The
> PageId in the page header = (4088:1863305327).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -190291108, index ID 0, page ID (3:1189). The PageId
> in the page header = (11478:-190291108).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -141766390, index ID 0, page ID (3:1349). The PageId
> in the page header = (11495:-141766390).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -134217730, index ID 55543, page ID (3:6508). The
> PageId in the page header = (20969:-654835713).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -65259032, index ID 29704, page ID (3:6523). The
> PageId in the page header = (15448:-1958723189).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -49287057, index ID 3841, page ID (3:6450). The
> PageId in the page header = (28943:98791695).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -3041115, index ID 4033, page ID (3:6469). The PageId
> in the page header = (55136:264792335).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -966656, index ID 1, page ID (3:6218). The PageId in
> the page header = (0:12).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -61291, index ID 65535, page ID (3:6512). The PageId
> in the page header = (35323:-140914551).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -19470, index ID 7325, page ID (3:6472). The PageId
> in the page header = (46607:269284336).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -13896, index ID 65280, page ID (3:6479). The PageId
> in the page header = (258:-4063233).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -3002, index ID 7, page ID (3:6509). The PageId in
> the page header = (19851:1856).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -421, index ID 21641, page ID (3:6478). The PageId in
> the page header = (0:1300019285).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -1, index ID 0, page ID (3:1086). The PageId in the
> page header = (1:4096).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -1, index ID 0, page ID (3:1090). The PageId in the
> page header = (0:30).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -1, index ID 0, page ID (3:1273). The PageId in the
> page header = (1:4096).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID -1, index ID 0, page ID (3:1337). The PageId in the
> page header = (0:0).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 32768, page ID (3:6722). The PageId in
> the page header = (0:-2147483648).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 32833, page ID (3:1271). The PageId in
> the page header = (0:152).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 34283, page ID (3:1075). The PageId in
> the page header = (0:48).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 34283, page ID (3:1183). The PageId in
> the page header = (0:152).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 34283, page ID (3:1216). The PageId in
> the page header = (0:152).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 34283, page ID (3:1268). The PageId in
> the page header = (0:152).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 65535, page ID (3:943). The PageId in the
> page header = (0:268437512).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 65535, page ID (3:1076). The PageId in
> the page header = (0:160).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 65535, page ID (3:1208). The PageId in
> the page header = (0:160).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page ID (3:926). The PageId in the
> page header = (0:0).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page ID (3:927). The PageId in the
> page header = (0:0).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page ID (3:928). The PageId in the
> page header = (40:65563).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page ID (3:929). The PageId in the
> page header = (0:0).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page ID (3:932). The PageId in the
> page header = (0:0).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page ID (3:933). The PageId in the
> page header = (0:0).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page ID (3:935). The PageId in the
> page header = (0:0).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page ID (3:937). The PageId in the
> page header = (11:0).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page ID (3:940). The PageId in the
> page header = (0:104).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page ID (3:941). The PageId in the
> page header = (0:268435456).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page ID (3:942). The PageId in the
> page header = (0:0).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page ID (3:961). The PageId in the
> page header = (0:0).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page ID (3:968). The PageId in the
> page header = (0:0).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page ID (3:971). The PageId in the
> page header = (0:0).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page ID (3:974). The PageId in the
> page header = (0:0).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page ID (3:975). The PageId in the
> page header = (0:0).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page ID (3:976). The PageId in the
> page header = (0:0).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page ID (3:987). The PageId in the
> page header = (0:268498052).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page ID (3:988). The PageId in the
> page header = (552:0).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page ID (3:989). The PageId in the
> page header = (0:0).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page ID (3:994). The PageId in the
> page header = (288:0).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page ID (3:996). The PageId in the
> page header = (0:1120).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page ID (3:997). The PageId in the
> page header = (0:0).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page ID (3:1000). The PageId in the
> page header = (0:0).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page ID (3:1003). The PageId in the
> page header = (0:0).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page ID (3:1004). The PageId in the
> page header = (640:0).
> Server: Msg 8909, Level 16, State 1, Line 1
> Table error: Object ID 0, index ID 0, page ID (3:1006). The PageId in the
> page header = (0:0).
>
>
>
>
>
>
Hi,

Check the following
http://support.microsoft.com/default.aspx?scid=kb;en-us;308795
It would appear you need a SP for your server.

James
Author
11 Feb 2006 1:30 PM
Islamegy®
I already have SQl Server 2000 SP4.. on win 2003 standard edition..
is there any other way to fix it??

Show quote
"James Wilson" <JamesWil***@bryggemail.dk> wrote in message
news:Ozy2iewLGHA.1048@TK2MSFTNGP10.phx.gbl...
> Islamegy® wrote:
>> When i try to open programs which my database it give this error.. so i
>> tried to run
>> DBCC CHECKDB and here is the result but i'm unable to repair it with
>> REPAIR_ALLOW_DATA_LOSS  or REPAIR_REBUILD
>> so how could i repair my database??
>>
>> Below is a part of the excution result but the group server don't allow
>> me to send the whole error..
>> I may send it by mail to anyone intersting to help me
>> thanx
>> ----------------------------------------------
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -2143188841, index ID 0, page ID (3:969). The
>> PageId
>> in the page header = (4:2097196).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -2143188841, index ID 0, page ID (3:1002). The
>> PageId
>> in the page header = (8:1572908).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -2143188841, index ID 0, page ID (3:1185). The
>> PageId
>> in the page header = (14:1572908).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -2113043956, index ID 33283, page ID (3:6095). The
>> PageId in the page header = (33298:-2112781808).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -1996486771, index ID 65535, page ID (3:6467). The
>> PageId in the page header = (1060:1552485445).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -1995680373, index ID 1060, page ID (3:6475). The
>> PageId in the page header = (9340:-1979711565).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -1983249921, index ID 59573, page ID (3:6464). The
>> PageId in the page header = (65535:-125572609).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -1980235758, index ID 1033, page ID (3:6545). The
>> PageId in the page header = (1033:1770505).
>> CHECKDB found 0 allocation errors and 3 consistency errors in table
>> '(Object
>> ID -2143188841)' (object ID -2143188841).
>> CHECKDB found 0 allocation errors and 1 consistency errors in table
>> '(Object
>> ID -2113043956)' (object ID -2113043956).
>> CHECKDB found 0 allocation errors and 1 consistency errors in table
>> '(Object
>> ID -1996486771)' (object ID -1996486771).
>> CHECKDB found 0 allocation errors and 1 consistency errors in table
>> '(Object
>> ID -1995680373)' (object ID -1995680373).
>> CHECKDB found 0 allocation errors and 1 consistency errors in table
>> '(Object
>> ID -1983249921)' (object ID -1983249921).
>> CHECKDB found 0 allocation errors and 1 consistency errors in table
>> '(Object
>> ID -1980235758)' (object ID -1980235758).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -1962934272, index ID 7204, page ID (3:6513). The
>> PageId in the page header = (53761:1784).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -1873442348, index ID 46607, page ID (3:6517). The
>> PageId in the page header = (55381:-1919924855).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -1844604404, index ID 37379, page ID (3:6096). The
>> PageId in the page header = (37394:-1844342256).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -1806302640, index ID 0, page ID (3:1077). The
>> PageId
>> in the page header = (11495:-140203890).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -1775632384, index ID 0, page ID (3:6315). The
>> PageId
>> in the page header = (0:0).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -1606079722, index ID 65535, page ID (3:6514). The
>> PageId in the page header = (14205:-168).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -1576164852, index ID 41475, page ID (3:6097). The
>> PageId in the page header = (41490:-1575902704).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -1465024753, index ID 61545, page ID (3:6489). The
>> PageId in the page header = (65535:-894388865).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -1307725300, index ID 45571, page ID (3:6098). The
>> PageId in the page header = (45586:-1307463152).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -1243779476, index ID 0, page ID (3:1256). The
>> PageId
>> in the page header = (11486:-1243779476).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -1242689680, index ID 0, page ID (3:1034). The
>> PageId
>> in the page header = (11659:911220612).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -1240526836, index ID 28431, page ID (3:6470). The
>> PageId in the page header = (4108:-202324724).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -1152210384, index ID 0, page ID (3:1082). The
>> PageId
>> in the page header = (0:268595332).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -1039285748, index ID 49667, page ID (3:6099). The
>> PageId in the page header = (49682:-1039023600).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -973271089, index ID 60175, page ID (3:6488). The
>> PageId in the page header = (6460:-1240465409).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -973043694, index ID 768, page ID (3:6249). The
>> PageId in the page header = (35131:-67074006).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -964489724, index ID 9844, page ID (3:6490). The
>> PageId in the page header = (40331:408259567).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -952557369, index ID 55433, page ID (3:6448). The
>> PageId in the page header = (49153:609061656).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -922677171, index ID 33745, page ID (3:6498). The
>> PageId in the page header = (0:69485767).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -805371899, index ID 44103, page ID (3:6850). The
>> PageId in the page header = (5:-571998203).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -764276784, index ID 49511, page ID (3:6471). The
>> PageId in the page header = (53362:266005263).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -757274380, index ID 1, page ID (3:6680). The
>> PageId
>> in the page header = (0:0).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -664137952, index ID 24847, page ID (3:6466). The
>> PageId in the page header = (63343:254302335).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -651129463, index ID 59573, page ID (3:6477). The
>> PageId in the page header = (46733:-9928).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -602944036, index ID 64527, page ID (3:6465). The
>> PageId in the page header = (53244:265738255).
>> Server: Msg 8939, Level 16, State 1, Line 1
>> Table error: Object ID -469760349, index ID 14592, page
>> (1700:1140852387).
>> Test (PageType == WF_PAGE && dbId == TEMPDBID) failed. Values are 24 and
>> 2.
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -451946649, index ID 28431, page ID (3:6442). The
>> PageId in the page header = (3848:-1202422001).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -360463723, index ID 45449, page ID (3:6521). The
>> PageId in the page header = (35072:53377).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -318903809, index ID 35592, page ID (3:6520). The
>> PageId in the page header = (31186:-2072480510).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -254999299, index ID 10751, page ID (3:6473). The
>> PageId in the page header = (4088:1863305327).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -190291108, index ID 0, page ID (3:1189). The
>> PageId
>> in the page header = (11478:-190291108).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -141766390, index ID 0, page ID (3:1349). The
>> PageId
>> in the page header = (11495:-141766390).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -134217730, index ID 55543, page ID (3:6508). The
>> PageId in the page header = (20969:-654835713).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -65259032, index ID 29704, page ID (3:6523). The
>> PageId in the page header = (15448:-1958723189).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -49287057, index ID 3841, page ID (3:6450). The
>> PageId in the page header = (28943:98791695).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -3041115, index ID 4033, page ID (3:6469). The
>> PageId
>> in the page header = (55136:264792335).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -966656, index ID 1, page ID (3:6218). The PageId
>> in
>> the page header = (0:12).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -61291, index ID 65535, page ID (3:6512). The
>> PageId
>> in the page header = (35323:-140914551).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -19470, index ID 7325, page ID (3:6472). The
>> PageId
>> in the page header = (46607:269284336).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -13896, index ID 65280, page ID (3:6479). The
>> PageId
>> in the page header = (258:-4063233).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -3002, index ID 7, page ID (3:6509). The PageId in
>> the page header = (19851:1856).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -421, index ID 21641, page ID (3:6478). The PageId
>> in
>> the page header = (0:1300019285).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -1, index ID 0, page ID (3:1086). The PageId in
>> the
>> page header = (1:4096).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -1, index ID 0, page ID (3:1090). The PageId in
>> the
>> page header = (0:30).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -1, index ID 0, page ID (3:1273). The PageId in
>> the
>> page header = (1:4096).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID -1, index ID 0, page ID (3:1337). The PageId in
>> the
>> page header = (0:0).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID 0, index ID 32768, page ID (3:6722). The PageId in
>> the page header = (0:-2147483648).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID 0, index ID 32833, page ID (3:1271). The PageId in
>> the page header = (0:152).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID 0, index ID 34283, page ID (3:1075). The PageId in
>> the page header = (0:48).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID 0, index ID 34283, page ID (3:1183). The PageId in
>> the page header = (0:152).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID 0, index ID 34283, page ID (3:1216). The PageId in
>> the page header = (0:152).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID 0, index ID 34283, page ID (3:1268). The PageId in
>> the page header = (0:152).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID 0, index ID 65535, page ID (3:943). The PageId in
>> the
>> page header = (0:268437512).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID 0, index ID 65535, page ID (3:1076). The PageId in
>> the page header = (0:160).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID 0, index ID 65535, page ID (3:1208). The PageId in
>> the page header = (0:160).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID 0, index ID 0, page ID (3:926). The PageId in the
>> page header = (0:0).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID 0, index ID 0, page ID (3:927). The PageId in the
>> page header = (0:0).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID 0, index ID 0, page ID (3:928). The PageId in the
>> page header = (40:65563).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID 0, index ID 0, page ID (3:929). The PageId in the
>> page header = (0:0).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID 0, index ID 0, page ID (3:932). The PageId in the
>> page header = (0:0).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID 0, index ID 0, page ID (3:933). The PageId in the
>> page header = (0:0).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID 0, index ID 0, page ID (3:935). The PageId in the
>> page header = (0:0).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID 0, index ID 0, page ID (3:937). The PageId in the
>> page header = (11:0).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID 0, index ID 0, page ID (3:940). The PageId in the
>> page header = (0:104).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID 0, index ID 0, page ID (3:941). The PageId in the
>> page header = (0:268435456).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID 0, index ID 0, page ID (3:942). The PageId in the
>> page header = (0:0).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID 0, index ID 0, page ID (3:961). The PageId in the
>> page header = (0:0).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID 0, index ID 0, page ID (3:968). The PageId in the
>> page header = (0:0).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID 0, index ID 0, page ID (3:971). The PageId in the
>> page header = (0:0).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID 0, index ID 0, page ID (3:974). The PageId in the
>> page header = (0:0).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID 0, index ID 0, page ID (3:975). The PageId in the
>> page header = (0:0).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID 0, index ID 0, page ID (3:976). The PageId in the
>> page header = (0:0).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID 0, index ID 0, page ID (3:987). The PageId in the
>> page header = (0:268498052).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID 0, index ID 0, page ID (3:988). The PageId in the
>> page header = (552:0).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID 0, index ID 0, page ID (3:989). The PageId in the
>> page header = (0:0).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID 0, index ID 0, page ID (3:994). The PageId in the
>> page header = (288:0).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID 0, index ID 0, page ID (3:996). The PageId in the
>> page header = (0:1120).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID 0, index ID 0, page ID (3:997). The PageId in the
>> page header = (0:0).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID 0, index ID 0, page ID (3:1000). The PageId in the
>> page header = (0:0).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID 0, index ID 0, page ID (3:1003). The PageId in the
>> page header = (0:0).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID 0, index ID 0, page ID (3:1004). The PageId in the
>> page header = (640:0).
>> Server: Msg 8909, Level 16, State 1, Line 1
>> Table error: Object ID 0, index ID 0, page ID (3:1006). The PageId in the
>> page header = (0:0).
>>
>>
>>
>>
>>
>>
> Hi,
>
> Check the following
> http://support.microsoft.com/default.aspx?scid=kb;en-us;308795
> It would appear you need a SP for your server.
>
> James
Author
11 Feb 2006 8:27 PM
Erland Sommarskog
Islamegy® (NULL_Islamegy_N***@yahoo.com) writes:
> When i try to open programs which my database it give this error.. so i
> tried to run
> DBCC CHECKDB and here is the result but i'm unable to repair it with
> REPAIR_ALLOW_DATA_LOSS  or REPAIR_REBUILD
> so how could i repair my database??

Do you have a backup of your database? If not, you may be in trouble.
Your database looks to be in pretty bad shape.

I would recommend opening a case with Microsoft. It's not going to be
cheap, but you will have weigh it against the cost of losing the data
entirely.

--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

AddThis Social Bookmark Button

Post Other interesting topics
how to obtain further error information?
Why is this statement blocking...
NESTED SQL QUESTION and aggregate function
CLR Triggers and inserted table
SQL script, split digits and letters