Resetting the Suspect

Hi ,
How can I Resetting the Suspect of the database in Sqlserver database ?
Regards ,
ChuongYou can use sp_resetstatus as described in the Books Online:
EXEC sp_resetstatus N'MyDatabase'
Also, review the SQL Server error log for messages indicating why the
database was marked as suspect.
--
Hope this helps.
Dan Guzman
SQL Server MVP
--
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--
"Trang" <trangtran86@.hotmail.com> wrote in message
news:exFNr34dDHA.3592@.tk2msftngp13.phx.gbl...
> Hi ,
> How can I Resetting the Suspect of the database in Sqlserver database
?
> Regards ,
> Chuong
>