RS First Dynamics NAV Blog

...from NAV 3.60 to NAV 2013
Home Blogs | Home | Login | Contact | My Profile | RSS | About | Cerca

Recovering Sql DB from "Suspect state"

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...
Categoria: Sql Server ALL
giovedì, 10 set 2009 Ore. 10.59

Scrivi un commento

Non è possibile inviare commenti a questo Blog


Copyright © 2002-2007 - Blogs 2.0 | Home Page Blogs
ASP.NET 2.0 Windows 2003