none
求助:sql2000数据库有错误,修复后的提示。 RRS feed

  • 问题

  • 说明一下情况:windows server 2003 +windows sql 2000,
    平时维护的时候看到以下错误信息(第一段),然后想到是数据库有损坏,需要修复,下面第二段是修复数据库的执行语句,第三段,第四段,第五段文字为3个修复语句执行的结果,省略了那些正常的信息,只贴出错误的提示信息,省略了数据库名称。使用dbcc checkdb(@databasename,REPAIR_ALLOW_DATA_LOSS)无法修复,是什么原因?有没有解决方法?



    ------------------------------------------------------------------------
    第一段

    错误日志如下:
    事件類型:    錯誤

    事件來源:    MSSQL$FFFFF

    事件類別目錄:    (2)

    事件識別碼:    17052

    日期:        2011-12-31

    時間:        23:02:30

    使用者:        NT AUTHORITY\SYSTEM

    電腦:    FFFF

    描述:
    Error: 7105, Severity: 22, State: 3

    Page (1:1064), slot 3 for text, ntext, or image node does not exist.


    -----------------------------------------------------------------------------------

    第二段;


    Use master

    declare @databasename varchar(255)

    set @databasename='MYDATABASENAME'


    exec sp_dboption@databasename,N'single',N'true'

    dbcc checkdb(@databasename,REPAIR_FAST)

    dbcc checkdb(@databasename,REPAIR_REBUILD)

    dbcc checkdb(@databasename,REPAIR_ALLOW_DATA_LOSS)

    exec sp_dboption@databasename,N'single',N'false'




    ----------------------------------------------------------------------------------------------------------
    第三段

    Server: Msg 8929, Level 16, State 1, Line 6

    Object ID 2: Errors found in text ID1042874368 owned by data record identified by RID = (1:10768:6) id = 613577224and indid = 8.

    Server: Msg 8965, Level 16, State 1, Line 6

    Table error: Object ID 2. The text, ntext,or image node at page (1:1064), slot 3, text ID 1042874368 is referenced bypage (1:866), slot 4, but was not seen in the scan.

    Server: Msg 8964, Level 16, State 1, Line 6

    Table error: Object ID 2. The text, ntext,or image node at page (1:1128), slot 3, text ID 1042874368 is not referenced.

    DBCC results for 'MYDATABASENAME'.

    DBCC results for 'sysobjects'.

    There are 799 rows in 12 pages for object'sysobjects'.

    DBCC results for 'sysindexes'.


    The repair level on the DBCC statement caused this repair to bebypassed.


    The repair level on the DBCC statement caused this repair to bebypassed.


    The repair level on the DBCC statement caused this repair to bebypassed.

    There are 1569 rows in 103 pages for object'sysindexes'.

    CHECKDB found 0 allocation errors and 3consistency errors in table 'sysindexes' (object ID 2).

    CHECKDB found 0 allocation errors and 3consistency errors in database 'MYDATABASENAME'.

    DBCC execution completed. If DBCC printederror messages, contact your system administrator.



    -------------------------------------------------------------------------------------

    第四段


    Server: Msg 8929, Level 16, State 1, Line7

    Object ID 2: Errors found in text ID1042874368 owned by data record identified by RID = (1:10768:6) id = 613577224and indid = 8.

    DBCC results for 'MYDATABASENAME'.

    DBCC results for 'sysobjects'.

    There are 799 rows in 12 pages forobject 'sysobjects'.

    DBCC results for 'sysindexes'.

    Server: Msg 8965, Level 16, State 1,Line 7

    Table error: Object ID 2. The text,ntext, or image node at page (1:1064), slot 3, text ID 1042874368 is referencedby page (1:866), slot 4, but was not seen in the scan.

    Server: Msg 8964, Level 16, State 1,Line 7

    Table error: Object ID 2. The text,ntext, or image node at page (1:1128), slot 3, text ID 1042874368 is notreferenced.


    The repair level on the DBCC statement caused this repair to bebypassed.


    The repair level on the DBCC statement caused this repair to bebypassed.


    The repair level on the DBCC statement caused this repair to bebypassed.

    There are 1569 rows in 103 pages forobject 'sysindexes'.

    CHECKDB found 0 allocation errors and 3consistency errors in table 'sysindexes' (object ID 2).

    CHECKDB found 0 allocation errors and 3consistency errors in database 'MYDATABASENAME'.

    DBCC execution completed. If DBCCprinted error messages, contact your system administrator.


    ------------------------------------------------------------------------------------------------------

    第五段:


    Server: Msg 8929, Level 16, State 1,Line 8

    Object ID 2: Errors found in text ID1042874368 owned by data record identified by RID = (1:10768:6) id = 613577224and indid = 8.

    Server: Msg 8965, Level 16, State 1,Line 8

    Table error: Object ID 2. The text,ntext, or image node at page (1:1064), slot 3, text ID 1042874368 is referencedby page (1:866), slot 4, but was not seen in the scan.

    Server: Msg 8964, Level 16, State 1,Line 8

    Table error: Object ID 2. The text,ntext, or image node at page (1:1128), slot 3, text ID 1042874368 is notreferenced.

    DBCC results for 'MYDATABASENAME'.

    DBCC results for 'sysobjects'.

    There are 799 rows in 12 pages forobject 'sysobjects'.

    DBCC results for 'sysindexes'.


    The repair level on the DBCC statement caused this repair to bebypassed.


    The repair level on the DBCC statement caused this repair to bebypassed.


    The repair level on the DBCC statement caused this repair to bebypassed.

    There are 1569 rows in 103 pages forobject 'sysindexes'.

    CHECKDB found 0 allocation errors and 3consistency errors in table 'sysindexes' (object ID 2).

    CHECKDB found 0 allocation errors and 3consistency errors in database 'MYDATABASENAME'.

    DBCC executioncompleted. If DBCC printed error messages, contact your system administrator.

    Ms,nice !
    • 已编辑 shuian 2012年1月7日 6:06
    2012年1月7日 6:04

答案