Suspect olan database i bulmak ?

[Emrahgs]

sql server 2000 de suspect durumuna düşmüş database i bulan sql kodu varmı sp_helpdb suspectleri listelemiyor

[zuzuu]

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

[Emrahgs]

hayır ben suspect olan databasi nasıl tamir ederiz diye sormamaıştım
ama çözümü buldum

Select DatabasePropertyEx ('Database_adi', 'Status')
suspect olanlarda suspect olmayanlarda online yazıyor