none
Checkdb found 6 allocation errors , how to fix ? RRS feed

  • Question

  • HI Experts,

    checkdb found  6 allocation errors, how to fix ?

    Thanks in Advance!

    Vijay

    Tuesday, April 15, 2014 6:33 AM

Answers

  • Can yoy pls post the detail error msg, because we cant get the allocation error in Index page or Data page.If its in Index page so please recreate the index.

    if data means,if u have latest backup means resore it.


    Thanks - SelvaKumarSubramaniam.Please MARK AS ANSWER, if my answer is useful to U.

    Tuesday, April 15, 2014 7:01 AM

  • Causes
    file system corruption, 
    underlying hardware system issues, 
    driver issues, 
    corrupted pages in memory, 
    problems with the SQL Server Engine. 

    Possible solutions 

    1.best solution if CHECKDB reports consistency errors is to restore from a known good backup.
    2. If you cannot restore from a backup, then CHECKDB provides a feature to repair errors.
    3. If system level problems such as the file system or hardware may be causing these problems, it is recommended you correct these first before restoring or running repair.       4. Allocation error in Index page, please recreate the index.

    Thanks - Vanchan.Please MARK AS ANSWER, if my answer is useful to U.




    • Edited by Vanchan Tuesday, April 15, 2014 10:35 AM
    • Marked as answer by vijay_1234 Tuesday, April 15, 2014 11:46 AM
    Tuesday, April 15, 2014 10:34 AM
  • HI Experts,

    checkdb found  6 allocation errors, how to fix ?

    Thanks in Advance!

    Vijay

    For this simple question without enough detail about corruption answer will be restore from latest valid backup and check SQL server errorlog and eventviewer to find out why your database got corrupted.Finding reason is very important so that you cna mitigate it.

    Do you have valid backups ?


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers


    Tuesday, April 15, 2014 10:39 AM
    Moderator
  • Hi Shanky,

    we re-created indexes . problem is resloved.

    Thanks very much shanky.

    Tuesday, April 15, 2014 11:49 AM

All replies

  • Can yoy pls post the detail error msg, because we cant get the allocation error in Index page or Data page.If its in Index page so please recreate the index.

    if data means,if u have latest backup means resore it.


    Thanks - SelvaKumarSubramaniam.Please MARK AS ANSWER, if my answer is useful to U.

    Tuesday, April 15, 2014 7:01 AM

  • Causes
    file system corruption, 
    underlying hardware system issues, 
    driver issues, 
    corrupted pages in memory, 
    problems with the SQL Server Engine. 

    Possible solutions 

    1.best solution if CHECKDB reports consistency errors is to restore from a known good backup.
    2. If you cannot restore from a backup, then CHECKDB provides a feature to repair errors.
    3. If system level problems such as the file system or hardware may be causing these problems, it is recommended you correct these first before restoring or running repair.       4. Allocation error in Index page, please recreate the index.

    Thanks - Vanchan.Please MARK AS ANSWER, if my answer is useful to U.




    • Edited by Vanchan Tuesday, April 15, 2014 10:35 AM
    • Marked as answer by vijay_1234 Tuesday, April 15, 2014 11:46 AM
    Tuesday, April 15, 2014 10:34 AM
  • HI Experts,

    checkdb found  6 allocation errors, how to fix ?

    Thanks in Advance!

    Vijay

    For this simple question without enough detail about corruption answer will be restore from latest valid backup and check SQL server errorlog and eventviewer to find out why your database got corrupted.Finding reason is very important so that you cna mitigate it.

    Do you have valid backups ?


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers


    Tuesday, April 15, 2014 10:39 AM
    Moderator
  • https://www.sqlskills.com/blogs/paul/category/checkdb-from-every-angle/

    What are the errors ?


    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    Tuesday, April 15, 2014 11:40 AM
    Moderator
  • Extent (9:760033) in database ID 19 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
    CHECKDB found 1 allocation errors and 0 consistency errors not associated with any single object.
    CHECKDB found 1 allocation errors and 0 consistency errors in database 'xxx'.
    Tuesday, April 15, 2014 11:47 AM
  • Hi Shanky,

    we re-created indexes . problem is resloved.

    Thanks very much shanky.

    Tuesday, April 15, 2014 11:49 AM
  • Thanks Uri,

    we re-created indexex, problem is resolved.

    Tuesday, April 15, 2014 11:49 AM
  • Hi Selvaons,

    as you suggested, we re-created indexex, it is  working well. Thanks very much :)

    Tuesday, April 15, 2014 11:51 AM
  • Hi Vanchan,
    Thanks very much for your time.
    Tuesday, April 15, 2014 11:52 AM