Project Server 2003 - SQL Server Data Base - "Suspect" mode

[sdolores]

Hi,
I use Project Server 2003 with SQL Server 2000 on Windows 2003 Server.
I have a lot of problems with de data base. Frequently it become in the
"suspect" mode. I dont know why this happen.
When this occure I can't go back and I've to restore the data base form
same backup.
Any one of you have this problem?
Any suggestion?
Thanks!

Dolores

 

[FaisalM]

Dolores,

The 'suspect' database problem might happen due to reasons like missing log
file, corrupt database, limited space on system etc.

I'm not sure what exactly might have caused this for you. You should look
into SQL logs & event viewer log for some clue.

Also read these articles. One of these might help in your scenario.

1. Help! My Database is Marked Suspect.
http://www.sqlservercentral.com/columnists/bknight/unmarksuspect.asp

2. Missing device causes database to be marked suspect
http://support.microsoft.com/kb/180500

3. FIX: A database is marked suspect when you open the database in SQL
Server 2000
http://support.microsoft.com/kb/889266/

4. How to restore a SQL Server database marked as "suspect"
http://www.devx.com/vb2themax/Tip/18624


FaisalM
http://www.FaisalMasood.com/

My Project Blog
http://msp.faisalmasood.com/
My Sharepoint Blog
http://sps.faisalmasood.com/