Post reply

Error 8968: Table Error: IAM Page

  • March 3, 2006 at 7:57 am

    #170819

    Hi I'm looking for some help on the following error:

    Error 8968: Table Error: IAM Page(1:126078)(Object ID xxxxxxxx, Index ID 0) is out of range of this database.

    The error occurred when skrinking the log file

    Does anyone know what has caused this, and what's the solution to fix the error.

    Cheers

  • March 3, 2006 at 11:18 am

    #624688

    Sounds like you have some corruption.  Have you run CHECKDB?

  • January 21, 2008 at 2:37 am

    #770070

    I used command DBCC CHECKDB and this option no problem solution

  • January 21, 2008 at 11:39 pm

    #770349

    This is a clear cut corruption issue, the heap table is effected.

    1. check the hardware by running diagnostic tool. check the system event log and replace the effected hardware.

    2. Restore the database from the backup

    3. if no backup is available then run dbcc checkdb with repair allow data loss. The IAM page is effected, performing a repair will cause the IAM chain to be rebuilt the page or the page is de-allocated. Data loss is sure. Better to have a good backup.

    "More Green More Oxygen !! Plant a tree today"

  • January 22, 2008 at 12:07 am

    #770353

    Minaz Amin (1/21/2008)

    This is a clear cut corruption issue, the heap table is effected.

    1. check the hardware by running diagnostic tool. check the system event log and replace the effected hardware.

    2. Restore the database from the backup

    3. if no backup is available then run dbcc checkdb with repair allow data loss. The IAM page is effected, performing a repair will cause the IAM chain to be rebuilt the page or the page is de-allocated. Data loss is sure. Better to have a good backup.

    Thanks Minaz Amin,

    I used this method and my exapmle is exhibits below:

    -- change mode for single_user

    alter database Place_Optivum set single_user

    --full repair database

    dbcc checkdb ('Place_Optivum', REPAIR_ALLOW_DATA_LOSS)

    -- change mode for multi_user

    alter database Place_Optivum set multi_user

    this steps isn't solution problem too.

    I'm looking for the system log, application log and SQL Server log and i'm not see anything wrong.

    Thanks for help me,

  • January 22, 2008 at 12:34 am

    #770357

    Ok .. then ..got it while shrinking you receive this error. There is known issue let me check

    "More Green More Oxygen !! Plant a tree today"

  • January 22, 2008 at 12:49 am

    #770361

    Hi Mark and Lukaszm

    Your issue may be related to this KB http://support.microsoft.com/kb/892803

    "More Green More Oxygen !! Plant a tree today"

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply