Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have found following errors when I use DBCC CHECKDB command.

I don't have idea to fix the error. please help me.

CHECKDB found 124 allocation errors and 0 consistency errors not associated with any single Object.
CHECKDB found 124 allocation errors and 0 consistency errors in database 'Database Name'.

This is my production database so I want to fix ASAP.

Help me..

share|improve this question
add comment

migrated from stackoverflow.com Jul 15 '11 at 14:35

This question came from our site for professional and enthusiast programmers.

1 Answer

Not done this myself, but this looks like what you need to read: http://msdn.microsoft.com/en-us/library/aa258278(v=sql.80).aspx

This bit in the remarks seemed like it might be useful:

DBCC CHECKDB is the safest repair statement because it identifies and repairs the widest possible errors. If only allocation errors are reported for a database, execute DBCC CHECKALLOC with a repair option to repair these errors. However, to ensure that all errors, including allocation errors, are properly repaired, execute DBCC CHECKDB with a repair option rather than DBCC CHECKALLOC with a repair option.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.