Post reply

transaction

  • February 2, 2011 at 8:50 am

    #157420

    Is there any way that a committed transaction can be rolled back in MSSQL?

  • February 2, 2011 at 9:00 am

    #1281507

    Unfortunately we cannot rollback the committed transaction. Only the way as of I know restore the database.

    Check the transaction Log Schedules, If its available. How frequently you do that? Try to restore with possible closest Log. And Update the further information. Correct me if something else.

  • February 2, 2011 at 9:03 am

    #1281513

    You can restore the database under a different name, then apply the transaction log up to the point before the transaction occured. What you do next depends on the complexity of the the transaction that you want to "undo".

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

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