View Single Post
Eski 30/09/2007, 17:41   #2 (permalink)
zuzuu
Eski Cevizci
 
zuzuu Adlı Üyenin Profil Grafiği
 
Üyelik Tarihi: 05/2005
Mesaj: 289
Varsayılan

Sine you cannot access your db currrently as it is marked suspect, try to bring it normal as follows,

1.execute this ssms sp_resetstatus 'dbname' and after that you need to restart sql services........if this method fails,



2.try to detach the db and then again attach it it should come online but if you cannot attach the db after detaching it try as follows,

(a) create a database with the same name in another directory as the one you're trying to attach
(b) re-create all filesgroups and files as necessary
(c) shutdown the server
(d) swap in the old mdf file and any ndf files
(e) bring up the server and let the database attempt to be recovered and then go into suspect mode
(f) put the database in single_user and emergency modes
(g) run DBCC CHECKDB (dbname, REPAIR_ALLOW_DATA_LOSS) which will rebuild the log and run full repair
(h) return database to online, multi_user mode



3.if you fail in steps 1 and 2 you need to put the db into emergency mode

ALTER DATABASE DBNAME SET EMERGENCY and after that you can export the datas to another db using import export option..........

http://forums.microsoft.com/MSDN/Sho...77204&SiteID=1
zuzuu hatta değil   Alıntı Yaparak Yanıtla