October 1, 2008 at 12:59 pm
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
October 1, 2008 at 1:45 pm
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