Home Forums SQL Server 2005 Administering rollback delete command RE: rollback delete command

  • September 9, 2010 at 9:06 am

    #1218695

    GilaMonster (7/18/2008)

    free_mascot (7/18/2008)

    You can't recover deleted rows unless and untill you are using checkpoint.

    Checkpoints happen automatically and just write dirty data pages to disk. It's BEGIN TRANSACTION that allows data modifications to be rolled back.

    Hello Gail, you get about, don't you? 😀

    Let me ask you this; if he issues a Delete statement at 5pm, demolishing 50 rows in .05 seconds, could he not take a TLog backup at 5.05pm, and then do a point-in-time restore to 4.59Pm?