Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Location
    Far away from heaven
    Posts
    194

    Unanswered: Transaction Log!

    BEGIN TRAN
    DELETE FROM mytable
    ROLLBACK

    My question is, does this info remains in the transaction log if the recovery model is full, even if the transaction is rolled-back? I mean if i restore the log to this point, delete shall be run and then rolled back during the restore??

    Does transaction log contains the STATEMENT only, or actual rows?


    Thanx!

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    Log keeps all commited transaction with all data, not only statements. In your example rollback will remove part of log created by delete statement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •