Click here to Skip to main content
15,796,734 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I dropped a table in SQL server 2008 R2 by mistake.Is there any possible way to retrieve the table.Restoring the database using the .bak file seems to be a big process since the size of the .bak file is too large.Also is it possible to raise error /provide warning when executing the DROP statements in a database even when a user is given permissions? Kindly help in this regard.
Thanks in advance.

Manikandan V
[no name] 10-Dec-13 13:46pm    
Do you expect an undo function for this (dropping a table)? Think about what this would mean. Ok, I agree, it would be very comfortable, but it is also very unrealistic :)

Share this answer
U need to make a new database with different name and restore the .bak file into that database. Now from there only export that table which u have deleted previously. Drop the new database and your problem will be solved.

Hope,This will help you...
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900