Restoring Databases

5 pts.
Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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 <a href=”http://www.quest.com/litespeed-for-sql-server”>Lightspeed for SQL Server</a> or <a href=”http://www.lumigent.com/”>LogExplorer</a> 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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following