Data deleted - how to tell when? (using .bak and .trn)

Question

Post reply

Data deleted - how to tell when? (using .bak and .trn)

Viewing 5 posts - 31 through 34 (of 34 total)

You must be logged in to reply to this topic. Login to reply

nealhudson77 SSC-Addicted Points: 491 More actions · Answer 1

Thanks

I realise it won't give me the User - but will it give me the time?

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

nealhudson77 (11/11/2010)
I realise it won't give me the User - but will it give me the time?

If you restore the logs, all that you will see in any auditing/tracing tool is the RESTORE LOG commands, nothing else. The restore log doesn't open a connection and run all the commands, it just makes the changes directly to the tables. It also doesn't put all the restored commands into the DB's transaction log.

If all you have is the log backups, then the best you can get is what a log reader tool (like the Apex one) gives you, and it may be necessary to buy a licence for that.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass