Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Martincruise
Starting Member
1 Post |
 Posted - 2009-10-14 : 10:39:01
|
| When I scan SQL Server 2000 database than I face 8909 errorServer: Msg 8905, Level 16, State 1, Line 1 Extent (1:192) in database ID 10 is marked allocated in the GAM, but no SGAM or IAM has allocated it.How can I resolve it? |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-10-14 : 11:44:16
|
Please run the following and post the full and complete output. No way I can give you a recommendation without seeing everything that's wrong with the DB.DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS Do you have a clean backup (one without the corruption)--Gail ShawSQL Server MVP |
 |
|
|
Davidpoul
Starting Member
14 Posts |
Posted - 2009-10-15 : 01:10:22
|
| To resolve the issue, you can follow any of these methods:1. Install SQL Server 2000 Service Pack 2 and run DBCC CHECKDB command with repair_allow_data_loss option2. Use DTS (Data Transformation Services) and transfer the database out.If the above measures don’t help or the database still appears to be corrupt, you need to use efficient third-party SQL Repair applications.David Poulhttp://www.mssqldatabaserecovery.com |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-10-15 : 01:35:53
|
quote:
Originally posted by Davidpoul1. Install SQL Server 2000 Service Pack 2 and run DBCC CHECKDB command with repair_allow_data_loss option2. Use DTS (Data Transformation Services) and transfer the database out.
You missed the primary one. Restore from backup.Without the full output of CheckDB there's no way to say what the best solution is.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Face 8909 Error