Pete.Dumbelton


Hi,

SQL Server 2005

When I try to attach a SDE data.mdf I get.

SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:3067392; actual 0:0). It occurred during a read of page (1:3067392) in database ID 10 at offset 0x000005d9c00000 in file 'E:\ODYSSEUS SDE Data\MSSQL.1\MSSQL\Data.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. Could not open new database 'sde'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 824)

Is there anyway to fix this DB so it can be attached.

Thanks for your thoughts & comments...




Re: Can't attach DB, reports Error 824

Deepak Rangarajan


Try performing the below steps,
  • Create a database with the same name in another directory as the one you're trying to attach.
  • Re-create all filesgroups and files as necessary and shutdown the server.
  • Swap in the old mdf file and any ndf files.
  • Bring up the server and let the database attempt to be recovered and then go into Suspect.
  • Put the database in single-user mode.
  • Run DBCC CHECKDB (dbname, REPAIR_ALLOW_DATA_LOSS) which will rebuild the log and run full repair
  • Return database to online, multi-user mode.
to start sql server in single user mode type the below command in cmd,
NET START MSSQLSERVER /c /m