Question

vijay_1234 on Tue, 15 Apr 2014 06:33:59


HI Experts,

checkdb found  6 allocation errors, how to fix ?

Thanks in Advance!

Vijay


Sponsored



Replies

Miruthann on Tue, 15 Apr 2014 07:01:10


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.

Vanchan on Tue, 15 Apr 2014 10:34:11



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.




Shanky_621 on Tue, 15 Apr 2014 10:39:27


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


Uri Dimant on Tue, 15 Apr 2014 11:40:38


https://www.sqlskills.com/blogs/paul/category/checkdb-from-every-angle/

What are the errors ?

vijay_1234 on Tue, 15 Apr 2014 11:47:36


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'.

vijay_1234 on Tue, 15 Apr 2014 11:49:02


Hi Shanky,

we re-created indexes . problem is resloved.

Thanks very much shanky.

vijay_1234 on Tue, 15 Apr 2014 11:49:41


Thanks Uri,

we re-created indexex, problem is resolved.

vijay_1234 on Tue, 15 Apr 2014 11:51:06


Hi Selvaons,

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

vijay_1234 on Tue, 15 Apr 2014 11:52:12


Hi Vanchan,
Thanks very much for your time.