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 (19)

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 (14)

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 (14)

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 (4)

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.
Streaming your games for others to watch on Twitch is a big fad these days, but it looks like the company is taking the first tentative steps towards branching into other areas.
According to a new dataset, the big names in technology lag well behind actors, politicians and athletes in terms of global cultural significance
Numbers show that paid peering arrangements result in measurable increases in service quality.
The space agency has published a catalog of its software being made available to the public, and it includes code for things other than flying a rocket to the moon
Facebook can't be faulted for following the same path as other mass media channels that came before it with regards to advertising, but there are many marketers who are still hoping for something different this time around.
In today's accessible technology roundup: The impact of ARIA on screen reader developers, Quail could be threatened by software patents and how to choose an accessible color palette
A few lucky customers of the AmazonFresh grocery store will be able to order products just by speaking into the Amazon Dash, a futuristic wand that the company started offering by invitation on Friday.
Add the Amazon Fire TV to your pile of streaming media boxes
Prosecutors will recommend three-month prison sentence for insider who allegedly shared info with French blogger.
Based on the expected annual return, computer science degrees from state universities pay off better than those from private schools

White Papers & Webcasts

See more White Papers | Webcasts

Join us:
Facebook

Twitter

Pinterest

Tumblr

LinkedIn

Google+