I've my database, testdb, ended up in Suspect state. The SQL log shows " I/O error 38(Reached the end of the file.) detected during read at offset xxxxxxxxxx in file '\testdb_Data.MDF'" during recovery. I do not have backup to restore the database from. So to run DBCC CHECKDB, I tried to put the database in emergency(bypass recovery) mode usingupdate sysdatabases set status = 32768 where name = 'testdb'DBCC CHECKDB showed some allocation and consistency errors and suggested "repair_allow_data_ 
Leggi tutto il post...