dbcc checkdb returns error

Question

dbcc checkdb returns error

daproud

SSC Enthusiast

Points: 179
More actions
March 21, 2008 at 11:02 am

#187691

I get the following error message after running checkdb
Is there a way to determine what data I will lose if I run repair_allow_data_loss?
Restoring from backup is not an option as I am not sure when this occurred because we do not run checkdb on a consistent basis.
Server: Msg 8905, Level 16, State 1, Line 3
Extent (3:1304880) in database ID 11 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 'TXMHNW'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (TXMHNW ).
Thanks,
Dave

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Paul Randal One Orange Chip Points: 29544 More actions · Answer 1

Given the structure of your database at present, no object or index has that extent allocated so running repair will not lose any data. Looks like something in the IO subsystem flipped a bit in the GAM page bitmap.

Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005

Jason Selburg SSC-Insane Points: 24641 More actions · Answer 2

More info here .. http://msdn2.microsoft.com/en-us/library/aa275767(SQL.80).aspx

______________________________________________________________________

Personal Motto: Why push the envelope when you can just open it?

If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

Jason L. Selburg

Paul Randal One Orange Chip Points: 29544 More actions · Answer 3

Interesting - I wrote the error descriptions document that these MSDN are taken from and it should contain the 'what will repair do section'. For this error, all that will happen is the erroneous bit in the GAM page will be reset.

See http://www.sqlskills.com/blogs/paul/2008/03/14/InsideTheStorageEngineGAMSGAMPFSAndOtherAllocationMaps.aspx for more details.

Thanks

Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005

daproud SSC Enthusiast Points: 179 More actions · Answer 4

Paul,

Thanks for the good news. I have recently started reading the blogs at SQLskills.com and find them interesting and informative.

Thanks again,

Dave