restore deleted table-2

pts.
Tags:
SQL
1. How can I restore a single table that was accidentally deleted by not performing a full database restore? 2.How can I track the machine who deleted that table? Thanks

Answer Wiki

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

Is this for SQL Server 2000?

You have a couple of options if you don’t want to replace all the data in your database. You could restore your backup to a new database and export only the missing table to its original database. You could also restore a specific transaction log if you back those up regularly, but that would roll back all transactions since the backup to that point.

As for tracking the machine where deletion command came from, that is more difficult. If you have audit logging enabled, you’ll be able to view the logs and see who was logged in at the time. You won’t be able to see the details of individual commands unless you were performing a trace at the time which captured the machine name, login name, sql command, etc.

Hope this helps,
Stephen

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
  • JeffCote
    Good morning. The person who responded earlier is correct, and potentially for Oracle as well. If you ARE dealing with Oracle, I believe you can also use DataMiner to retrieve the table and its information, provided the table data was "deleted" and not "truncated". Or, you can restore the database in a temporary location to a time previous to the table delete, export it out, and import the information into your production database. With regard to logging who the culprit was, you can turn on auditing. Oracle's auditing is extremely configurable, allowing you to track by schema, user, table, system privileges.... The list goes on and on. I actually do my own auditing as well on my databases where I track TERMINAL, IPADDRESS, USER_NAME (OS user), DDL_DATE, DDL_TYPE, OBJECT_TYPE, OWNER, and OBJECT_NAME. (I have a vendor who makes changes on the fly sometimes, and I want to know what he's done in case something "mysteriously" stops working.) I hope this helps. :-) Jeff
    0 pointsBadges:
    report

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