Question

  Asked: Mar 17 2008   6:57 AM GMT
  Asked by: H100


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

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



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.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Storage and SQL Server.

Looking for relevant Storage Whitepapers? Visit the SearchStorage.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Mrdenny  |   Mar 17 2008  6:31PM GMT

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.