I have a database that has been marked
SUSPECT because the volume that both the data and the log file were on suddenly disappeared (an accident - this is a developer workstation). I tried bringing the database back online:
ALTER DATABASE D SET ONLINE
That did nothing. On the web the procedure
sp_resetstatus is being recommended but it appears to be obsolete.
I do not wish to run
DBCC CHECKDB, at least not right now. The database is very big. What is the official way to bring a
SUSPECT database online as quickly as possible?