Roolback some rows

  • Hi Every body,

    Unfortunatuly i had delete some row in my table in Quary Analysier

    How can i retirve those row could you anybody plz help me

    Thanks

  • QA likes to run in an auto-commit mode. If your statement block didn't start with a BEGIN TRAN and end with a ROLLBACK TRAN, you'll need to resort to a backup to get those rows back.

    If the data you deleted is on a production server, you have my sympathies... in that case, you might want to consider restoring a backup to a separate database, then find what you deleted, and then manually INSERT them back into the production database.

    If you're lucky enough to have a frequent transaction log backup, you can also perform a restore to a point in time from the log (assuming the database is using the Full recovery model).

    --SJTerrill--

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

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