same on the desktop, which is quite beefy...

Thanks for all the information - it's been very helpful

The main .trn file is 3.5Gb, the Apex tool throws an out of memory exception on my laptop when I try...

Thanks

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

The Apex tool isn't giving me much...

Ok what about this:

I restore the first backup (.bak @ 2am)

I turn on audit tracing

I restore the 4 .trn files

What would that give me?

Apologies, my bad

GilaMonster (11/11/2010)

---

It's not transaction logging that you want.

SQL logs all transactions, for database integrity and recoverability. Depending on the recovery model those stay in the transaction log for different...

That Apex tool only works on SQL 2000 🙁

Do you reckon using that Apex tool I'd be able to narrow it down as to when the records got deleted?

Ok I'm no SQL Server expert - I'm the developer.

The last time the issue happened, I asked the Sys Admin / DBA person for the relevant SQL log files so...

Thanks guys, seem to be up sh*t creek with this one...

This is the second time the data has been mysteriously deleted from the server. I wrongly assumed that turning on...

This returns 0

🙁

Thanks.

Is there any way to parse this file to look at transaction?

I know the table name the records were deleted from, and...

Really?...

I'm not sure but I don't think so