Allocation error in Database in sql server 2008?

Question

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

Answer 1

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.