SQL 2005 table was crashed ??

[kakakaka77]

Our company is using SQL 2005 + VB program to store data. Recently we start to have problem with one of the tables of the database. The data of the table was disappeared for some reason. It happened serveral times, what we can do just restore the table. Everything is fine after that. But it will happen some time later. What is the problem more likely is, the table or the VB application ? Can anyone provide any thought help me to start to work on this problem?

Thank you very much!!

 

[mrdenny]

Sounds like the table (or the index being used to find the record) has become corrupt. You'll want to run a DBCC CHECKDB command against the database to check for corruption. If there is some, it'll tell you.

If there is none, then you'll want to check the application code to see where the records are being deleted.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog