Home Forums SQL Server 7,2000 Data Corruption Suddenly Data Loss RE: Suddenly Data Loss

  • July 25, 2011 at 12:58 pm

    #1358078

    Nemachtiani (6/22/2011)

    Hi all

    Does anyone know what would cause data loss on tables after commit with no errors raised neither executed DELETEs?

    Is this a symptom of database corruption?

    I have seen this just twice from thousands records, using exactly the same Net Frmework code and Stored Procedure, suddenly there's no record in two tables that always must have data.

    There's no chance to avoid inserting in those tables.

    thanks for any advice.

    do you have any triggers? a trigger rolling back because it was poorly coded could cause the original command(insert, update, etc) to rollback as well, resulting an an apparrent data loss.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!