hi to all.
I have a question about SQL 2005 Expres edition.
Waht makes SQL to mark some of databases as SUSPECT ?
Before few weeks i had that kind of problem but i fixed
by seting database in EMERGENCY mode and with DTSWizard i transfer
the Tables in new database, but i want to know what is the reason this database to be mark as SUSPECTET ?
I'will be very grateful if somebody can explain to me why
SQL 2005 Express is doing this.

Suspect means that "At least the primary may be damaged. The database cannot be recovered during the startup of SQL Server. The database is unavailable."

Thank's but i already know that.
I was wondering how is that possibl the databasse is working correctly you are shuting down computer at the end of you working time and when in the morning you turn on yor computer and run SQL your databesse is mark as SUSPECT ????????????????????

I have seen a database as suspect is for two reasons. The first is that the database is corrupt, and the corruption can be for any reason. Try running DBCC CHECKDB and see what comes back. This will check the logical and physical integrity of all the objects in the specified database.

The second reason it might be corrupt is that the drive the database on is bad (corrupt sectors, blocks, etc). There are tools and utilities available to determine the state of your drive.

I hope this helps...

Thanks SQLScott i will run the DBCC CHECKDB with your last replay i can say PROBLEM SOLVE. :D


Again 10x SQLScott.