Can anyone help me?
I've got one database in my development environment that after machine crashes when SQL Server starts this database stays in SUSPECT status.
I send you the errorlog with errors, can you tell me how can i recover my database with or without data loss.
Thanks and Regards,
2008-02-08 13:09:58.23 spid19s Error: 824, Severity: 24, State: 2.
2008-02-08 13:09:58.23 spid19s SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x50d7a8c4; actual: 0xd5a37a53). It occurred during a read of page (1:1678481) in database ID 5 at offset 0x00000333922000 in file 'D:\SQL_DATA\PTC_QS.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.
2008-02-08 13:09:58.31 spid19s Error: 3313, Severity: 21, State: 2.
2008-02-08 13:09:58.31 spid19s During redoing of a logged operation in database 'PTC_QS', an error occurred at log record ID (50862:16816:84). Typically, the specific failure is previously logged as an error in the Windows Event Log service. Restore the database from a full backup, or repair the database.
2008-02-08 13:09:58.32 spid19s Error: 3414, Severity: 21, State: 1.
2008-02-08 13:09:58.32 spid19s An error occurred during recovery, preventing the database 'PTC_QS' (database ID 5) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support.