Home Forums SQL Server 2005 Data Corruption MDF-Can't Get Out Of Suspect Mode....Need Some Help Please RE: MDF-Can't Get Out Of Suspect Mode....Need Some Help Please

  • Here are the results of

    DBCC CheckDB ('DBNAME', REPAIR_ALLOW_DATA_LOSS)

    DBCC results for 'DBNAME'.

    CHECKDB found 0 allocation errors and 0 consistency errors in database 'DBNAME'.

    Msg 824, Level 24, State 2, Line 1

    SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:776; actual 0:0). It occurred during a read of page (1:776) in database ID 5 at offset 0x00000000610000 in file 'E:\DBNAME2005.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.

    Msg 824, Level 24, State 2, Line 1

    SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:776; actual 0:0). It occurred during a read of page (1:776) in database ID 5 at offset 0x00000000610000 in file 'E:\DBNAME2005.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.

    Msg 824, Level 24, State 2, Line 1

    SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:776; actual 0:0). It occurred during a read of page (1:776) in database ID 5 at offset 0x00000000610000 in file 'E:\DBNAME2005.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.

    Msg 824, Level 24, State 2, Line 1

    SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:776; actual 0:0). It occurred during a read of page (1:776) in database ID 5 at offset 0x00000000610000 in file 'E:\DBNAME2005.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.

    Msg 7909, Level 20, State 1, Line 1

    The emergency-mode repair failed.You must restore from backup.DBNAME