Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Express Edition and Compact Edition (2005)  Cause of Suspect Database

Author  Topic  mgilmour Starting Member 1 Post Posted - 2009-10-13 : 12:30:33 Hello, We run SQL Express 2005 in a very high vibration environment on a tablet PC with high G-shock hard drives. However from time to time we get the dreaded "suspect" database on main table. I am wondering if this is known to be a hardware issue vs. something being done at a software level? Once we restore the database and/or run a chkdsk on the drive all is well again. One solution i have is to auto rebuild the table each day to ensure it's integrity. The table does not keep historical data so at the end of the day it's empty. thanks for help or advice you can give. Mogenns