DB Help on SQL Server
-
I have some DB corruption and I don't have a good recent backup. All data appears to be fine, but when I run a DBCC CHECKDB I get this
Msg 8905, Level 16, State 1, Line 1
Extent (1:1534320) in database ID 7 is marked allocated in the GAM, but no SGAM or IAM has allocated it.When I google the error I find a Microsoft Article about the error which leads me to this table. https://technet.microsoft.com/en-us/library/Aa275767(v=SQL.80).aspx
[img]
Can someone help me better understand this error and what impact it could have? It appears everything is working properly. I have tried copying the DB to a test server and running DBCC CheckDB ('Database', REPAIR_ALLOW_DATA_LOSS) and even that will not remove the Allocation Error.
-
Never ran across an error like that.
For a long way around solution, if you do not have a recent backup, do you have an old one?
Restore it as a differently named DB and see if it is corrupt also.
If not, then run something like RedGate SQL Compare and check structure is all the same.
If/Once the structure is the same, run a job to export all the data from the live DB to the TestDB
-
Looks like hardware issues are the expected source.
-
@scottalanmiller said:
Looks like hardware issues are the expected source.
This goes back to the VMWare issue that I posted about before.
-
If anyone is interested, Robert for Microsoft on Spiceworks was a huge help on this issue. He has really helped me narrow it down and given me a possible resolution.
http://community.spiceworks.com/topic/1175896-allocation-error-in-sql-database
