SQL Server 2008 R2 – How to Recover Deleted Table from Database

disaster recoveryrecoverysql serversql-server-2008-r2

Currently I deleted one table from the database. But now I want some of the information from that table.

Please suggest how to restore or get back the table.

I am using SQL Server 2008 R2.

Best Answer

You can restore the BACKUP with a different name in the same instance and follow steps below.

1) restore the database ( right click on databases > Restore ( it can be in the same instance )) with a differente name.

2) In this new database ( The restored one ) , open tables , search the table you've deleted, right button, Script table as > CREATE TO. This will crate a Script. Execute it on the old database ( the one you have deleted the table). It will create the structure of that table.

3) Now you can do something like this:

USE [Old Database] 
GO 
SELECT * INTO [the blank table you've created in the new database] 
FROM [the table on the backup, that has Data]

This will copy the data from the backup table, to the table you created.

Related Question