restore deleted table-2

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,

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.
  • 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:

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.

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


Share this item with your network: