suspect database

Question

Hi, Please help me with this. My sql server 2000 database has been marked suspect after power failure. 
Thanks in advance 

Answer 1

Hi

Can you post the error messages from SQL Error Log?

Do you have a recent backup? Your best chance of successfully recovering from this situation is reverting to a recent backup.

HTH

Ewan

---

If you have found this post helpful, please click the 'Vote as Helpful' link (the green triangle and number on the top-left).

If this post answers your question, click the 'Mark As Answered' link below. It helps others who experience the same issue in future to find the solution.

Answer 2

Hi ,

Have a look at this article http://www.mssqltips.com/tip.asp?tip=1204 , it explains the causes and ways to fix it.

---

Thanks, Leks