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

  • June 23, 2011 at 12:50 am

    #1342820

    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?

    No.

    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.

    Someone's run a delete or truncate on the tables. Could be manually, could be from app. You'll have to run profiler to tell.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass