Professional Web Applications Themes

Rollback update - Microsoft SQL / MS SQL Server

hi folks, I have accidentally UPDATEed huge amount of data that is in a table. I need to rollback it....is there any way to do it using log file without executing another UPDATE statement. Thanks in advance....

  1. #1

    Default Rollback update

    hi folks,
    I have accidentally UPDATEed huge amount of data that is in a table.
    I need to rollback it....is there any way to do it using log file without
    executing another UPDATE statement.
    Thanks in advance.


    Venkatesan M Guest

  2. #2

    Default Re: Rollback update

    If your database's recovery model is full/bulk-logged you will have to do
    point in time recovery. Point in time recovery can be done with the help of
    combination of full/differential and transacation log backups.
    Look for topic "Recovering to a Point In Time" / "Restoring a Database to a
    Prior State" in Books online

    --
    -Vishal
    "Venkatesan M" <venkat_asphotmail.com> wrote in message
    news:OAMQwZHRDHA.1712TK2MSFTNGP12.phx.gbl...
    > hi folks,
    > I have accidentally UPDATEed huge amount of data that is in a table.
    > I need to rollback it....is there any way to do it using log file without
    > executing another UPDATE statement.
    > Thanks in advance.
    >
    >

    Vishal Parkar Guest

  3. #3

    Default rollback update

    Hello all, I want to be able to not update a row in a table if an existing
    flag has been set in one of the columns. What would be the most
    efficient/elegant way to perform this?

    1. Check for column value in stored proc and only if not set then do update.
    2. Write a trigger which checks column in deleted table and if present
    rollback update? is this possible?

    thanks!


    RP Guest

  4. #4

    Default Re: rollback update

    Put the expression in your WHERE clause of the UPDATE statement.

    WHERE YourFlag <> 1 and YOurOtherSargs

    --

    Andrew J. Kelly
    SQL Server MVP


    "RP" <rpnospam.com> wrote in message
    news:uBOM4G$RDHA.2852tk2msftngp13.phx.gbl...
    > Hello all, I want to be able to not update a row in a table if an existing
    > flag has been set in one of the columns. What would be the most
    > efficient/elegant way to perform this?
    >
    > 1. Check for column value in stored proc and only if not set then do
    update.
    > 2. Write a trigger which checks column in deleted table and if present
    > rollback update? is this possible?
    >
    > thanks!
    >
    >

    Andrew J. Kelly Guest

Similar Threads

  1. Can't rollback
    By dee32 in forum Macromedia Contribute General Discussion
    Replies: 0
    Last Post: June 23rd, 01:34 AM
  2. Rollback 7.0.2 to 7.0.1
    By Diacritical in forum Coldfusion Server Administration
    Replies: 9
    Last Post: August 29th, 08:31 PM
  3. Rollback problem
    By Couro in forum Macromedia Contribute General Discussion
    Replies: 0
    Last Post: July 11th, 06:20 PM
  4. HELP - Rollback
    By Jeffdag in forum Macromedia Contribute General Discussion
    Replies: 2
    Last Post: April 14th, 04:15 PM
  5. CFTRANSACTION w/ ROLLBACK
    By akosz in forum Macromedia ColdFusion
    Replies: 6
    Last Post: March 7th, 08:37 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139