When I scan SQL Server 2000 database than I face 8909 error

Server: 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?

Try running a DBCC CHECKDB for that DB and see what it says your options
are.

--

Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Martincruise" <u55457@uwe> wrote

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Â*option

2. 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. you can
download it from
http://www.repair-mssql-database.com...r-software.php


--
David Poul
http://www.mssqldatabaserecovery.com

Message posted via http://www.sqlmonster.com