Thursday, March 22, 2012

DB Tables Missing - Log Someplace?

Does MSSQL keep track of anything, anywhere related to tables being deleted
(when, by whom, etc.) from a DB if no type of auditing was setup?Hi
Yes, in the database transaction log. You can use 3rd party tools like LogPi
and Log Explorer to look at the transaction logs. this is assuming you have
full logging on and dump your transaction logs on a regular basis.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Absolutely" <abs@.spam.never> wrote in message
news:11aepite0idaacc@.corp.supernews.com...
> Does MSSQL keep track of anything, anywhere related to tables being
> deleted (when, by whom, etc.) from a DB if no type of auditing was setup?
>sql

No comments:

Post a Comment