Red Gate forums :: View topic - Forensic examination of Sql Server 2000 database
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Log Rescue
SQL Log Rescue forum

Forensic examination of Sql Server 2000 database

Search in SQL Log Rescue forum
Post new topic   Reply to topic
Jump to:  
Author Message
javif



Joined: 11 Jul 2014
Posts: 1

PostPosted: Fri Jul 11, 2014 2:42 am    Post subject: Forensic examination of Sql Server 2000 database Reply with quote

I´m a forensic examinator. I have a case with a Sql server 2000 database and I´m searching for old transactions. The database is in simple recovery model. I use SQL Log Rescue and I found a lot of transactions.

Now to present the case in court I have to obtain the same results through queries. I use "Select * from ::fn_dblogs" but I can obtain just the active portion of the log file. In Sql Server 2005 I can use DBCC TRACEON(2537) to read all the log file, but it doesn´t work in Sql Server 2000.

Does anybody know how SQL Log Rescue read all the log file (active and inactive) portion or if is there any way to do it through queries?

Thanks in advance
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group