Thursday, August 29, 2013

Extent (Error_ID) in database ID (DB_ID) is marked allocated in the GAM, but no SGAM or IAM has allocated it

Problem: I am getting a database error while checking database with DBCC CHECKDB command. The error message:
Extent (Error_ID) in database ID (DB_ID) is marked allocated in the GAM, but no SGAM or IAM has allocated it.

Solution: To resolve this error first try these sql commands:

    sp_dboption AMMS, single, true
    DBCC CHECKDB (AMMS, REPAIR_REBUILD)
    sp_dboption AMMS, single, false

This will  repair the error with no data loss.

In case of failure of above statements please try with following commands:

    exec sp_dboption AMMS, single, true
    begin try
    DBCC CHECKDB (AMMS, repair_allow_data_loss)
    end try
    begin catch
    DBCC CHECKDB (AMMS, repair_allow_data_loss)
    end catch
    exec sp_dboption AMMS, single, false

There may occur data loss with this statement.

This problem generally occurs when there is some hardware errors. Run hardware diagnostics and correct any problems. Fix any hardware related problems. It might find it beneficial to switch to a completely new hardware system.

1 comment:

  1. This way my acquaintance Wesley Virgin's biography starts with this SHOCKING AND CONTROVERSIAL VIDEO.

    Wesley was in the military-and shortly after leaving-he discovered hidden, "MIND CONTROL" secrets that the CIA and others used to get anything they want.

    These are the same secrets tons of celebrities (especially those who "became famous out of nowhere") and elite business people used to become rich and famous.

    You probably know that you use only 10% of your brain.

    Really, that's because most of your brainpower is UNCONSCIOUS.

    Maybe that expression has even occurred INSIDE your own head... as it did in my good friend Wesley Virgin's head around 7 years back, while driving an unlicensed, beat-up garbage bucket of a car with a suspended driver's license and with $3 in his pocket.

    "I'm very fed up with going through life payroll to payroll! Why can't I become successful?"

    You've taken part in those conversations, ain't it so?

    Your success story is waiting to start. All you have to do is in YOURSELF.

    Learn How To Become A MILLIONAIRE Fast

    ReplyDelete