What's the official successor for sp_resetstatus in case of a SUSPECT database?
As of SQL Server 2012, sp_resetstatus is still supported.  However, Paul Randal has some excellent counsel, including do not detach that database.

The first and best answer is to restore a good backup.  

If that does not work and you can retrieve the files from somewhere (where?), check out Paul's posts at:

http://www.sqlskills.com/blogs/paul/creating-detaching-re-attaching-and-fixing-a-suspect-database/
http://www.sqlskills.com/blogs/paul/checkdb-from-every-angle-emergency-mode-repair-the-very-very-last-resort/

Since these are detailed discussions, I will not rehash them. But read carefully.