April 9, 2007 at 10:51 pm
Hi experts,
is ther any way to rollback transaction inEnterprise manager? i wanted to run this query "select * from tablename" and by mistake i excute "delect from tablename" and my table records has been deleted. any way to rollback this....
thanx in advance
April 9, 2007 at 11:14 pm
Transaction is completed, so nothing to roll back.
It's hard to say if you can restore the data because it depends on many factors you did not show here.
Open BOL on RESTORE DATABASE and see what you can do.
There are plenty of options, just find which one could work in your actual circumstances.
_____________
Code for TallyGenerator
April 10, 2007 at 7:35 am
If you really need it, buy a log reader tool for the $300-500 and it can roll back based on the log if you're not in simple mode.
April 11, 2007 at 9:00 am
Sergiy and Steve provided the answer. It really depends on the recovery model of the database and if you have the backups properly set up and working, then you can restore to point in time. Otherwise you're out of luck. This is why anytime you type delete in the query analyzer you need to be very careful when before you execute.
Good day...
Bulent
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply