Google Groups Home
Help | Sign in
DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting
Home
+ new post
Pages
About this group
Join this group
Reading Log from Transaction Log Backup
Options
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
   5 messages - Collapse all
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
Muhammad Arif  
View profile
  More options Nov 20 2008, 4:58 pm
From: Muhammad Arif <brainsa...@gmail.com>
Date: Wed, 19 Nov 2008 21:58:36 -0800 (PST)
Local: Thurs, Nov 20 2008 4:58 pm
Subject: Reading Log from Transaction Log Backup
Reply | Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author
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


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Stephen Russell  
View profile
  More options Nov 21 2008, 2:42 am
From: "Stephen Russell" <sruss...@lotmate.com>
Date: Thu, 20 Nov 2008 09:42:03 -0600
Local: Fri, Nov 21 2008 2:42 am
Subject: RE: [DotNetDevelopment] Reading Log from Transaction Log Backup
Reply | Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author
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


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Brandon Betances  
View profile
  More options Nov 21 2008, 10:54 am
From: "Brandon Betances" <bbetan...@gmail.com>
Date: Thu, 20 Nov 2008 18:54:15 -0500
Local: Fri, Nov 21 2008 10:54 am
Subject: Re: [DotNetDevelopment] Re: Reading Log from Transaction Log Backup
Reply | Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author

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 <sruss...@lotmate.com>wrote:


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Stephen Russell  
View profile
  More options Nov 21 2008, 2:47 pm
From: "Stephen Russell" <sruss...@lotmate.com>
Date: Thu, 20 Nov 2008 21:47:56 -0600
Local: Fri, Nov 21 2008 2:47 pm
Subject: RE: [DotNetDevelopment] Re: Reading Log from Transaction Log Backup
Reply | Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author

It is the command and the change that occurs in binary.  

.........................

Stephen Russell -

Senior Visual Studio Developer, DBA

Memphis, TN

901.246-0159

From: DotNetDevelopment@googlegroups.com
[mailto:DotNetDevelopment@googlegroups.com] On Behalf Of Brandon Betances
Sent: Thursday, November 20, 2008 5:54 PM
To: DotNetDevelopment@googlegroups.com
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 <sruss...@lotmate.com>
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


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Brandon Betances  
View profile
  More options Nov 22 2008, 5:04 am
From: "Brandon Betances" <bbetan...@gmail.com>
Date: Fri, 21 Nov 2008 13:04:33 -0500
Local: Sat, Nov 22 2008 5:04 am
Subject: Re: [DotNetDevelopment] Re: Reading Log from Transaction Log Backup
Reply | Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author

If the OP really wants to make a log of all transactions, I would create a
class that writes to a text file or XML file the details you want to log and
build it in to the site/program. That way, when you do any CRUD, you can log
exactly what you want.

On Thu, Nov 20, 2008 at 10:47 PM, Stephen Russell <sruss...@lotmate.com>wrote:


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2009 Google