DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Corrupt Table

  1. #1
    Luke Smith Guest

    Corrupt Table


    Hello,

    I have one table in a DB with test data therein. This table is getting corrupted
    for not apparent reason. This has now happened 3 times. When I run Dbcc CheckTable
    for thereon the following message is returned:

    Server: Msg 7965, Level 16, State 2, Line 1
    Table corrupt: Could not check object ID 1075586970, index ID 0 due to invalid
    allocation (IAM) page(s).
    Server: Msg 8968, Level 16, State 1, Line 1
    Table Corrupt: IAM page (1:8192) (object ID 1075586970, index ID 0) is out
    of the range of this database.
    DBCC results for 'SpecificSdcEPairsMadeAvailable'.
    There are 0 rows in 0 pages for object 'SpecificSdcEPairsMadeAvailable'.
    CHECKTABLE found 0 allocation errors and 2 consistency errors in table 'SpecificSdcEPairsMadeAvailable'
    (object ID 1075586970).
    repair_allow_data_loss is the minimum repair level for the errors found by
    DBCC CHECKTABLE (NCNRI.dbo.SpecificSdcEPairsMadeAvailable ).

    Does anyone know what the cause of this problem is and how it can be solved?

    What affect will the 'repair_allow_data_loss' parameter have on the rest
    of the tables in the database? Will they be affected or not?

    All input will be highly appreciated.

    Thanks
    Luke Smith.

  2. #2
    Doug Buchanan Guest

    Re: Corrupt Table

    Make sure you don't have virus scanners or other file-level utilities
    messing with the sql files. Once you eliminate that, start looking at
    hardware as an issue and move the data files to a different physical disk if
    possible.

    The proposed repair solution means some pages may be discarded which could
    contain valid data. As to what effect that would have on the overall
    database, I couldn't say.

    "Luke Smith" <ekul@webmail.co.za> wrote in message
    news:3bb046f3$1@news.devx.com...
    >
    > Hello,
    >
    > I have one table in a DB with test data therein. This table is getting

    corrupted
    > for not apparent reason. This has now happened 3 times. When I run Dbcc

    CheckTable
    > for thereon the following message is returned:
    >
    > Server: Msg 7965, Level 16, State 2, Line 1
    > Table corrupt: Could not check object ID 1075586970, index ID 0 due to

    invalid
    > allocation (IAM) page(s).
    > Server: Msg 8968, Level 16, State 1, Line 1
    > Table Corrupt: IAM page (1:8192) (object ID 1075586970, index ID 0) is out
    > of the range of this database.
    > DBCC results for 'SpecificSdcEPairsMadeAvailable'.
    > There are 0 rows in 0 pages for object 'SpecificSdcEPairsMadeAvailable'.
    > CHECKTABLE found 0 allocation errors and 2 consistency errors in table

    'SpecificSdcEPairsMadeAvailable'
    > (object ID 1075586970).
    > repair_allow_data_loss is the minimum repair level for the errors found by
    > DBCC CHECKTABLE (NCNRI.dbo.SpecificSdcEPairsMadeAvailable ).
    >
    > Does anyone know what the cause of this problem is and how it can be

    solved?
    >
    > What affect will the 'repair_allow_data_loss' parameter have on the rest
    > of the tables in the database? Will they be affected or not?
    >
    > All input will be highly appreciated.
    >
    > Thanks
    > Luke Smith.




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center