How to restore the database that has gone suspect

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

The restore job in one of the servers has failed
I ran the query on that job, The result for that query says
"The database is marked suspect,Transaction logs cannaot be restored, Use restore database to recover the database Restore log is terminated abnormally"
Give me tips on how to restore the databse in this situation

-- Anonymous, June 15, 2004

Answers

First you have to detach the database and attach the database again

-- Anonymous, June 16, 2004

Moderation questions? read the FAQ