Question

Restoring Databases

Restore, SQL Server, SQL Server database restore

Sir,
I have deleted a table in sql database.Is there any option to recover it without losing the data.Please reply

You will want to restore your most recent backup of the database to another database name or to another server, then script out the database and then copy the data from the restored database to the production database which is missing the table.

If your database is in full recovery mode or bulk logged recovery mode you can use a product like Lightspeed for SQL Server or LogExplorer to find the entry in your transaction log for the DROP TABLE command and roll back that command. Doing this will get back the table, but you will still need to get the data back out of an existing backup that you have.

If you have Lightspeed for SQL Server you can restore just that table from the backup file instead of restoring the entire database.