Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I got this error :

I/O error (torn page) detected during read at offset 0x0000024afe4000 in file for a user database. Using the first googled method, i set the database from master..sysdatabases from status 280 to status 24 but i still can't access it to run a DBCC CHECKDB.

What should I do ?

share|improve this question

2 Answers 2

up vote 1 down vote accepted

Take a backup of the log tail, then restore from your most recent full backup and apply all log backups. In other words, apply your disaster recovery plan which you prepared for.

share|improve this answer

Try starting the SQL Server in single user mode from the command prompt. Then flip the value to bring the database online then try running DBCC CHECKDB again.

Can you post any stack dump any information?

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.