It is the command and the change that occurs in binary.
......................... Stephen Russell - Senior Visual Studio Developer, DBA Memphis, TN 901.246-0159 From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Brandon Betances Sent: Thursday, November 20, 2008 5:54 PM To: [email protected] Subject: [DotNetDevelopment] Re: Reading Log from Transaction Log Backup The T-Log stores queries before they are executed, right Stephen? I know it has something to do with that, and even if you could parse it, i believe its all in binary; you wouldnt be able to read it. On Thu, Nov 20, 2008 at 10:42 AM, Stephen Russell <[EMAIL PROTECTED]> wrote: You can't. It is a working container for restore functionality. There are third party tools that are expensive that will parse the data within the log and allow you to reverse statements made within the log. Those are very expensive! ......................... Stephen Russell - Senior Visual Studio Developer, DBA Memphis, TN 901.246-0159 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Muhammad Arif Sent: Wednesday, November 19, 2008 11:59 PM To: DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting Subject: [DotNetDevelopment] Reading Log from Transaction Log Backup Hello All: I have taken backup of my database (Sql server 2000) i-e transaction log ... now how can i read the log of this backup file... Regards No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.175 / Virus Database: 270.9.6/1797 - Release Date: 11/19/2008 8:58 AM No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.175 / Virus Database: 270.9.6/1797 - Release Date: 11/20/2008 9:11 AM
