Home > IT Answers > SQL Server > Corrupting database in an VB.NET application in SQL Server 2005
SQL Server Ask the Experts
2,585 pts.
 Corrupting database in an VB.NET application in SQL Server 2005
SQL Server 2005, SQL Server database, VB.NET
I have a application in VB.NET with SQL Server 2005 Express Edition. In the last few days, the database is continuously corrupting. I repair it, but the problem continues. I revise my code, but I can't find transactions errors that could produce the problems. Do you have any general ideas?

Software/Hardware used:
ASKED: December 18, 2008  7:40 PM
UPDATED: December 23, 2008  8:06 AM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

More information will be needed as to what sort of corruption you are seeing.

Have you run a DBCC CHECKDB on the database to see what’s wrong with the database?

Denny Cherry
 64,550 pts.
 

there are problems with checksums, I fixed all them using dbcc checkdb or dbcc checktable, but I lost a few rows.
Now I think I have found the problem, new installations have new kind of computers and I tested them with program SQLioSlim, they don´t pass windows compatibility test to SQL Server, so I belive the problem is in then HW and not in our software
Sorry my english, I’m spanish

Chuso
 10 pts.