Post reply

Data Loss

  • January 19, 2011 at 7:47 am

    #245558

    Hi

    We have a SQL Server 2000 database and an Access 2003 adp front end.

    Staff have reported losing some data when accessing from a remote desktop. It appears they have completed their entire input, then when viewed at a later date it is either absent or truncated.

    I understand that SQL Server stores data to cache before writing it to disk. Is this correct - as I'm wondering if this may be causing the issue. If the front end appears correct, but the back-end database isn't storing the data - I can't think of anything else.

    If anybody has any ideas, I would be very grateful.

    Thanks

    Paul

  • January 19, 2011 at 7:56 am

    #1275320

    Nope.

    SQL supports the ACID requirements for relational databases. D stands for Durability. Once a transaction is committed, it is permanent, it cannot be lost due to power failures or anything else.

    If data is going missing then either the transactions are not committing (errors or disconnections) or someone is deleting it after the fact.

    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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply