August 27, 2010 at 6:20 am
Hi
We got following error while executing DBCC CHECKDB command
Failed:(-10734545784) Executing the query "DBCC CHECKDB WITH NO_INFOMSGS
" failed with the following error: "Extent (6:5008984) in database ID 48 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 'KM_Test'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (KM_Test).". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
I want to confirm whether runnign following command is the only solution
repair_allow_data_loss
or Rebuilding Index can fix this error
regards
ghanshyam
August 27, 2010 at 6:33 am
Restore from backup?
I'd also check for hardware related faults to see if you may have issues on this machine which could lead to further corruption in this or other databases on that server
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply