How can I recover a table that I dropped in SQL?

owen

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.

Tags: SQL, table
Topic: Business
Answer this Question

Answers

4 total
jimlynch
Vote Up (26)

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.

rousseau
Vote Up (20)

Christopher pretty much covers it. It's amazingly how a momentary slip-up can cause a major head ache. Good luck!

Christopher Nerney
Vote Up (20)

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.

 


 


 


Enrique Mallon
Vote Up (11)

To recover deleted tables safely you must use sql database recovery tool which is best solution for corrupt sql database. visit :- http://www.sqlrepairtool.org

Ask a question

Join Now or Sign In to ask a question.
Thanks to the cloud, the “as a service” trend is getting a little out of control
Technology companies make up almost half of the businesses ranked highest by their employees for culture and values in a new survey
For weeks we've heard rumors that Google would be acquiring Twitch. What a surprise when Amazon turned out to be the buyer. Are you ready for a "Buy now" button on your livestream?
You can get browser extensions to stop advertisers from tracking you, but until now there hasn't been one that can prevent you from getting suckered by hucksters on news sites.
Ryan Carmack, the 9 year-old son of the famed programmer and game designer, has released Pong-clone called Angry Face
Technology is changing the way every department, from marketing to human resources to finance, is achieving its goals.
Also, how Tweet-shaming saved me from cutting the cord
A new study reveals that Java developers make the most while JavaScript programmers are the most wanted
CIOs and venture capitalists can often educate each other on how to evaluate tech trends to successfully construct deals.
Mark Zuckerberg’s latest app takes onerous Terms of Service to a strange new level
Join us:
Facebook

Twitter

Pinterest

Tumblr

LinkedIn

Google+