How can I recover a table that I dropped in SQL?
I accidentally deleted a table when I meant to delete a column. It was just a moment when I was thinking about other things and entered in DROP TABLE XXXX. when I meant to enter ALTER TABLE XXXX. Is there any way to recover the table? I can dig into the backups, so it's not the end of the world, but that's not how I hoped to spend my Friday morning.
Answers
According to many commenters at Ask SQL Server Central, if you don't have a back-up, you're going to be out of luck.
However, one person writes, "There is an outside chance of getting the data if your O/S backup had an open file agent. Ask your backup team if they can restore from prior to the issue to a test environment and you may be able to get the data."
It's pretty much the same conclusion here: Forget about it, unless..."If the DROP TABLE was executed from within a transaction and that transaction has not yet been committed, you can roll it back."
Beyond that, some people suggest purchase or downloading a free trial version of a third-party product that is able to read the log file and reconstuct the table from that information.
- Share this answer
- Permalink
Related Questions
I'm provisioning my new office, and need a phone system, with maybe about five extensions. It probably doesn't make sense to deploy an...
Where’s a good place to learn about ERP? Is my company better off with using a cloud-hosted version than running it on our own SQL...
Is it possible to speed up the performance of our SQL queries by defragging our database server's RAID?
For a couple of decades, businesses have been standardizing on SQL-based databases for dealing with large data sets....
My company is seeking to push into new markets, and I'm wondering if there's a way to find government contracting opportunities that...
I think Christopher covered it well. It's crucial to have backups ready in case something like this happens. If you don't have them, you could be stuck with no options.