February 6, 2010 at 3:11 am
Good day, i urgently need help as i messed up.
I have to DB with all tables exactly the same one being Live & other Test.
Last night i truncated the incorrect DB table, i urgently ned to get it restored.
There are backups & I tried restroring but keep on getting the error: Opertion on device "....bak exceeded retry count."
But because i messed up I would like to do a rollback if possible, as the last avaialable restore I hope is fine as i can't restore (error of above) has data of the night before which is missing the data of the current day as of the truncate (truncate before backup)
I am not a DB but have rights, please help i dont want to bugger up more 🙁
Regards
February 6, 2010 at 6:58 am
You can only rollback if you ran the operation within a transaction and did not run the COMMIT TRANSACTION statement. I doubt that applies here.
Find a backup, restore it alongside and copy the data over. It's the only way you're going to get the data back.
If you have errors restring, then you actually have bigger problems than just deleted data, you have backups that aren't restorable. I strongly suggest you bring this to the attention of the DBAs immediatly. They can also help you restore the lost data.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply