How to restore the database that has gone suspectgreenspun.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
First you have to detach the database and attach the database again
-- Anonymous, June 16, 2004