How to Read SQL Transaction Log ...

Good day All
I am trying to read & Understand SQL Transaction Log.
For Online Log, I use DBCC LOG...but how to understand what Row Data means.
Also How to read BackedUp (Offline) Log File?
Any help would be much appreciated.
--
Ramanuj Brahmachary
Database Administrator
[ MCDBA, MCSE, MCSD ]Hi,
Try using the 3rd party tool Logexplorer from Lumigent
www.lumigent.com
Thanks
Hari
SQL Server MVP
"Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
news:68B9091E-649C-45C9-8B5B-4F9606FCC876@.microsoft.com...
> Good day All
> I am trying to read & Understand SQL Transaction Log.
> For Online Log, I use DBCC LOG...but how to understand what Row Data
> means.
> Also How to read BackedUp (Offline) Log File?
> Any help would be much appreciated.
> --
> Ramanuj Brahmachary
> Database Administrator
> [ MCDBA, MCSE, MCSD ]|||This is undocumented. There are third party tools that help you interpret
the log, such as Lumigent.
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://blogs.msdn.com/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
news:68B9091E-649C-45C9-8B5B-4F9606FCC876@.microsoft.com...
> Good day All
> I am trying to read & Understand SQL Transaction Log.
> For Online Log, I use DBCC LOG...but how to understand what Row Data
> means.
> Also How to read BackedUp (Offline) Log File?
> Any help would be much appreciated.
> --
> Ramanuj Brahmachary
> Database Administrator
> [ MCDBA, MCSE, MCSD ]|||I have some 3:rd party tools listed on my links page:
http://www.karaszi.com/SQLServer/links.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
news:68B9091E-649C-45C9-8B5B-4F9606FCC876@.microsoft.com...
> Good day All
> I am trying to read & Understand SQL Transaction Log.
> For Online Log, I use DBCC LOG...but how to understand what Row Data means.
> Also How to read BackedUp (Offline) Log File?
> Any help would be much appreciated.
> --
> Ramanuj Brahmachary
> Database Administrator
> [ MCDBA, MCSE, MCSD ]|||There are a number of tools available
http://aspfaq.com/show.asp?id=2449
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
news:68B9091E-649C-45C9-8B5B-4F9606FCC876@.microsoft.com...
> Good day All
> I am trying to read & Understand SQL Transaction Log.
> For Online Log, I use DBCC LOG...but how to understand what Row Data
> means.
> Also How to read BackedUp (Offline) Log File?
> Any help would be much appreciated.
> --
> Ramanuj Brahmachary
> Database Administrator
> [ MCDBA, MCSE, MCSD ]|||Thanks very much for the overwhelming response.
My apologies, I havent mentioned that I tried some 3rd party Log Readers &
what I understand is they do very similar but are able to interprete the Row
Data field output of DBCC LOG. I was trying to find out if I can also
interprete the value in Row Data.
Any help in interpreting the field [Row Data] of DBCC LOG is much
appreciated.
--
Ramanuj Brahmachary
Database Administrator, Bangalore
[ MCDBA, MCSE, MCSD ]
"Jasper Smith" wrote:
> There are a number of tools available
> http://aspfaq.com/show.asp?id=2449
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
> news:68B9091E-649C-45C9-8B5B-4F9606FCC876@.microsoft.com...
> > Good day All
> > I am trying to read & Understand SQL Transaction Log.
> > For Online Log, I use DBCC LOG...but how to understand what Row Data
> > means.
> > Also How to read BackedUp (Offline) Log File?
> >
> > Any help would be much appreciated.
> > --
> > Ramanuj Brahmachary
> > Database Administrator
> > [ MCDBA, MCSE, MCSD ]
>
>|||Also how to read BackedUp transaction LOG from file on disk.
--
Ramanuj Brahmachary
Database Administrator
[ MCDBA, MCSE, MCSD ]
"Ramanuj" wrote:
> Thanks very much for the overwhelming response.
> My apologies, I havent mentioned that I tried some 3rd party Log Readers &
> what I understand is they do very similar but are able to interprete the Row
> Data field output of DBCC LOG. I was trying to find out if I can also
> interprete the value in Row Data.
> Any help in interpreting the field [Row Data] of DBCC LOG is much
> appreciated.
> --
> Ramanuj Brahmachary
> Database Administrator, Bangalore
> [ MCDBA, MCSE, MCSD ]
>
> "Jasper Smith" wrote:
> > There are a number of tools available
> > http://aspfaq.com/show.asp?id=2449
> >
> > --
> > HTH
> >
> > Jasper Smith (SQL Server MVP)
> > http://www.sqldbatips.com
> > I support PASS - the definitive, global
> > community for SQL Server professionals -
> > http://www.sqlpass.org
> >
> > "Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
> > news:68B9091E-649C-45C9-8B5B-4F9606FCC876@.microsoft.com...
> > > Good day All
> > > I am trying to read & Understand SQL Transaction Log.
> > > For Online Log, I use DBCC LOG...but how to understand what Row Data
> > > means.
> > > Also How to read BackedUp (Offline) Log File?
> > >
> > > Any help would be much appreciated.
> > > --
> > > Ramanuj Brahmachary
> > > Database Administrator
> > > [ MCDBA, MCSE, MCSD ]
> >
> >
> >|||There is no documentation for interpreting the active log or a log backup. I have not seen any
scripts or anything to help with this.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
news:162E993E-BBA0-4AD0-858B-672E8D6C0198@.microsoft.com...
> Also how to read BackedUp transaction LOG from file on disk.
> --
> Ramanuj Brahmachary
> Database Administrator
> [ MCDBA, MCSE, MCSD ]
>
> "Ramanuj" wrote:
>> Thanks very much for the overwhelming response.
>> My apologies, I havent mentioned that I tried some 3rd party Log Readers &
>> what I understand is they do very similar but are able to interprete the Row
>> Data field output of DBCC LOG. I was trying to find out if I can also
>> interprete the value in Row Data.
>> Any help in interpreting the field [Row Data] of DBCC LOG is much
>> appreciated.
>> --
>> Ramanuj Brahmachary
>> Database Administrator, Bangalore
>> [ MCDBA, MCSE, MCSD ]
>>
>> "Jasper Smith" wrote:
>> > There are a number of tools available
>> > http://aspfaq.com/show.asp?id=2449
>> >
>> > --
>> > HTH
>> >
>> > Jasper Smith (SQL Server MVP)
>> > http://www.sqldbatips.com
>> > I support PASS - the definitive, global
>> > community for SQL Server professionals -
>> > http://www.sqlpass.org
>> >
>> > "Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
>> > news:68B9091E-649C-45C9-8B5B-4F9606FCC876@.microsoft.com...
>> > > Good day All
>> > > I am trying to read & Understand SQL Transaction Log.
>> > > For Online Log, I use DBCC LOG...but how to understand what Row Data
>> > > means.
>> > > Also How to read BackedUp (Offline) Log File?
>> > >
>> > > Any help would be much appreciated.
>> > > --
>> > > Ramanuj Brahmachary
>> > > Database Administrator
>> > > [ MCDBA, MCSE, MCSD ]
>> >
>> >
>> >|||wandering how 3rd party vendors interpreting it....
--
Ramanuj Brahmachary
Database Administrator
[ MCDBA, MCSE, MCSD ]
"Tibor Karaszi" wrote:
> There is no documentation for interpreting the active log or a log backup. I have not seen any
> scripts or anything to help with this.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
> news:162E993E-BBA0-4AD0-858B-672E8D6C0198@.microsoft.com...
> > Also how to read BackedUp transaction LOG from file on disk.
> > --
> > Ramanuj Brahmachary
> > Database Administrator
> > [ MCDBA, MCSE, MCSD ]
> >
> >
> > "Ramanuj" wrote:
> >
> >> Thanks very much for the overwhelming response.
> >>
> >> My apologies, I havent mentioned that I tried some 3rd party Log Readers &
> >> what I understand is they do very similar but are able to interprete the Row
> >> Data field output of DBCC LOG. I was trying to find out if I can also
> >> interprete the value in Row Data.
> >> Any help in interpreting the field [Row Data] of DBCC LOG is much
> >> appreciated.
> >> --
> >> Ramanuj Brahmachary
> >> Database Administrator, Bangalore
> >> [ MCDBA, MCSE, MCSD ]
> >>
> >>
> >> "Jasper Smith" wrote:
> >>
> >> > There are a number of tools available
> >> > http://aspfaq.com/show.asp?id=2449
> >> >
> >> > --
> >> > HTH
> >> >
> >> > Jasper Smith (SQL Server MVP)
> >> > http://www.sqldbatips.com
> >> > I support PASS - the definitive, global
> >> > community for SQL Server professionals -
> >> > http://www.sqlpass.org
> >> >
> >> > "Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
> >> > news:68B9091E-649C-45C9-8B5B-4F9606FCC876@.microsoft.com...
> >> > > Good day All
> >> > > I am trying to read & Understand SQL Transaction Log.
> >> > > For Online Log, I use DBCC LOG...but how to understand what Row Data
> >> > > means.
> >> > > Also How to read BackedUp (Offline) Log File?
> >> > >
> >> > > Any help would be much appreciated.
> >> > > --
> >> > > Ramanuj Brahmachary
> >> > > Database Administrator
> >> > > [ MCDBA, MCSE, MCSD ]
> >> >
> >> >
> >> >
>
>|||Thanks
--
Ramanuj Brahmachary
Database Administrator
[ MCDBA, MCSE, MCSD ]
"Tibor Karaszi" wrote:
> I have some 3:rd party tools listed on my links page:
> http://www.karaszi.com/SQLServer/links.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
> news:68B9091E-649C-45C9-8B5B-4F9606FCC876@.microsoft.com...
> > Good day All
> > I am trying to read & Understand SQL Transaction Log.
> > For Online Log, I use DBCC LOG...but how to understand what Row Data means.
> > Also How to read BackedUp (Offline) Log File?
> >
> > Any help would be much appreciated.
> > --
> > Ramanuj Brahmachary
> > Database Administrator
> > [ MCDBA, MCSE, MCSD ]
>
>|||Thanks
--
Ramanuj Brahmachary
Database Administrator
[ MCDBA, MCSE, MCSD ]
"Hari Prasad" wrote:
> Hi,
> Try using the 3rd party tool Logexplorer from Lumigent
> www.lumigent.com
> Thanks
> Hari
> SQL Server MVP
> "Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
> news:68B9091E-649C-45C9-8B5B-4F9606FCC876@.microsoft.com...
> > Good day All
> > I am trying to read & Understand SQL Transaction Log.
> > For Online Log, I use DBCC LOG...but how to understand what Row Data
> > means.
> > Also How to read BackedUp (Offline) Log File?
> >
> > Any help would be much appreciated.
> > --
> > Ramanuj Brahmachary
> > Database Administrator
> > [ MCDBA, MCSE, MCSD ]
>
>