How to recover table after drop it in SQL Server

sql sql-server restore recovery
KaKa picture KaKa · Apr 7, 2014 · Viewed 13.4k times · Source

I drop a table in SQL Server using this code: 

DROP TABLE temp

Now, I try to recover this table, but I don't know a solution.

Please, tell me a solution for this problem if you know.

Answer

Sharad picture Sharad · Apr 7, 2014

If DROP TABLE was executed inside the Transaction and it has not been committed then you can ROLLBACK. But if it isn't, then you need backup of your database. Recover your table from database. If backup is also not present, then search for 3rd party recovery tools.

Related questions

Restore DB — Error RESTORE HEADERONLY is terminating abnormally.

I have taken backup of SQL Server 2008 DB on server, and download them to local environment. I am trying to restore that database and it is keep on giving me following error. An exception occurred while executing a Transact-SQL statement …

Read More
How can I retrieve the logical file name of the database from backup file

I was looking into the steps of how to Restore Database Backup using SQL Script (T-SQL). Here are the steps: Database YourDB has full backup YourBackUpFile.bak. It can be restored using following two steps: Step 1: Retrieve the logical file …

Read More
How do you backup and restore a database as a copy on the same server?

I have a SQL2005 Express database that I would like to create a copy of on the same instance. How do you go about doing this with a script? I already have a script for generating the backup, but the …

Read More