InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 09:13:44 GMT20http://www.sqlservercentral.com/Forums/Topic498590-360-1.aspxdbcc checkdb can repair some things - see bol. Make sure you have a backup first.sometimes suspect status can be reset.call microsoft technical supportapexSQL log may be able to help you recover data and objects.Tue, 13 May 2008 07:24:18 GMTTheSQLGuruhttp://www.sqlservercentral.com/Forums/Topic498590-360-1.aspxThat depends on why the database is suspect.Please take a look at the SQL error log. See if you can find anyy message indicating why the DB has been marked suspect. There should be something in there.Have any changes been made to the server just before it went suspect?Are the data files where SQL's expecting to see them?Do you have a recent backup?Mon, 12 May 2008 01:58:40 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic498590-360-1.aspxhi..My database will be suspect...how can i retrive the data in suspect database.Mon, 12 May 2008 01:49:39 GMTanil-447510