Showing posts with label log. Show all posts
Showing posts with label log. Show all posts

Friday, March 30, 2012

Reading a transaction log file

I'm having alot of trouble reading a SQL 2000 transaction log backup file.
As far as I can see, Microsoft do not provide such a tool and so far I've
tried a product called "SLR" and "ApexSQL Log". Both look OK and work OK with
"small" log files.
My problem is that the file I need to look at is 581MB and both products
just fail miserably when trying to look at these files (I think there are
about 1.3 million transcations in this file).
Before asking why I need to look at this file, I must stress that its
because of problem (server running out of disk space, so log backups were not
happening) that the log grew so big. Unfortunately, the site does not have a
DBA and I've been called in, as this all came to light when 5 important
tables appeared to have been "re-created" (dropped and created empty, with no
indexes, etc...). That has all been recovered, but they want to know how this
happened!!
I know for a fact that this 581mb log backup contains the transactions that
did the damage.
Any other ideas will be welcome!!
Is there not a command line utility, such simpy dumps all the info in these
file to a nice readable text file?? Or should I just persevere with the 2
products mentioned above?
Thanks
Hi,
There is no command line utility to convert the transaction log to text
file. Probably you could try the Logexplorer from Lumigent.
www.lumigent.com
Thanks
Hari
SQL Server MVP
"Jason Harrington" <Jason Harrington@.discussions.microsoft.com> wrote in
message news:A0EAB1FD-BAC2-4201-8153-695DEEF11210@.microsoft.com...
> I'm having alot of trouble reading a SQL 2000 transaction log backup file.
> As far as I can see, Microsoft do not provide such a tool and so far I've
> tried a product called "SLR" and "ApexSQL Log". Both look OK and work OK
> with
> "small" log files.
> My problem is that the file I need to look at is 581MB and both products
> just fail miserably when trying to look at these files (I think there are
> about 1.3 million transcations in this file).
> Before asking why I need to look at this file, I must stress that its
> because of problem (server running out of disk space, so log backups were
> not
> happening) that the log grew so big. Unfortunately, the site does not have
> a
> DBA and I've been called in, as this all came to light when 5 important
> tables appeared to have been "re-created" (dropped and created empty, with
> no
> indexes, etc...). That has all been recovered, but they want to know how
> this
> happened!!
> I know for a fact that this 581mb log backup contains the transactions
> that
> did the damage.
> Any other ideas will be welcome!!
> Is there not a command line utility, such simpy dumps all the info in
> these
> file to a nice readable text file?? Or should I just persevere with the
> 2
> products mentioned above?
> Thanks
|||I'm currently in discussion with a UK reseller of this product. The
evaluation version of this product only allows you to run against "northwind"
database and one of their own.
I asked if it would be able to read a 581mb file and they said if we were
interested in buying the product, they would test it for us!!!
Not really what I wanted to hear!!
I've been running SLR all day since 9.30am this morning, its now 3.30pm and
its about 75% of the way through reading it!!! We 'll see.....
Thanks for your response.
Jason
"Hari Prasad" wrote:

> Hi,
> There is no command line utility to convert the transaction log to text
> file. Probably you could try the Logexplorer from Lumigent.
> www.lumigent.com
> Thanks
> Hari
> SQL Server MVP
> "Jason Harrington" <Jason Harrington@.discussions.microsoft.com> wrote in
> message news:A0EAB1FD-BAC2-4201-8153-695DEEF11210@.microsoft.com...
>
>
|||We use Log Explorer and I've used it on much bigger log files than that with
no real issues.
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
"Jason Harrington" <JasonHarrington@.discussions.microsoft.com> wrote in
message news:907814B5-F9D3-492A-B024-E8DC00EFF538@.microsoft.com...[vbcol=seagreen]
> I'm currently in discussion with a UK reseller of this product. The
> evaluation version of this product only allows you to run against
> "northwind"
> database and one of their own.
> I asked if it would be able to read a 581mb file and they said if we were
> interested in buying the product, they would test it for us!!!
> Not really what I wanted to hear!!
> I've been running SLR all day since 9.30am this morning, its now 3.30pm
> and
> its about 75% of the way through reading it!!! We 'll see.....
> Thanks for your response.
> Jason
> "Hari Prasad" wrote:

reading a transaction log

Does anyone know of a utilty that i can use to open and view the transaction
log file.
one such utility: Log Explorer from Lumigent www.lumigent.com
Keith
"Emil" <laserview@.hotmail.com> wrote in message
news:eUFUu7QaEHA.1764@.TK2MSFTNGP10.phx.gbl...
> Does anyone know of a utilty that i can use to open and view the
transaction
> log file.
>
|||Microsoft doesn't provide a tool for reading the transaction log files, but
you might want to look at Lumigent Log Explorer (www.lumigent.com) or Log
P.I. (www.logpi.com).
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Emil" <laserview@.hotmail.com> wrote in message
news:eUFUu7QaEHA.1764@.TK2MSFTNGP10.phx.gbl...
> Does anyone know of a utilty that i can use to open and view the
> transaction
> log file.
>
|||In message <#w9QtDRaEHA.2972@.TK2MSFTNGP12.phx.gbl>, Keith Kratochvil
<sqlguy.back2u@.comcast.net> writes
>one such utility: Log Explorer from Lumigent www.lumigent.com
>
Just for completeness, there are a couple more-
Log PI
(http://www.logpi.com/)
Log Navigator
http://www.apexsql.com/index_lognavigator.htm
Personally I have used Log Explorer quite happily.
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Reading a log file

Hi all,
Is it possible to read a log file to see what changes have been done on a
particular table at a particular time? And if yes, how?
Thanks,
Ivan> Is it possible to read a log file to see what changes have been done on a
> particular table at a particular time? And if yes, how?
http://www.aspfaq.com/2449|||Keep in mind that transaction logs are truncated during backups.
"Ivan Debono" <ivanmdeb@.hotmail.com> wrote in message
news:OsmBwZfjFHA.1968@.TK2MSFTNGP14.phx.gbl...
> Hi all,
> Is it possible to read a log file to see what changes have been done on a
> particular table at a particular time? And if yes, how?
> Thanks,
> Ivan
>

Wednesday, March 28, 2012

read trn log backup files

What product is out there that can read a Transaction Backup file?
A restore was done but they didn't apply a couple of transaction logs. I
need to see what data is in these backup logs. If there is a product that
can do this can it apply the data from the logs or dump it to a file?
Thanks.
I've listed some on my links page:
http://www.karaszi.com/SQLServer/links.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"AHartman" <Hoosbruin@.Kconline.com> wrote in message news:OS70VXD3HHA.212@.TK2MSFTNGP05.phx.gbl...
> What product is out there that can read a Transaction Backup file?
> A restore was done but they didn't apply a couple of transaction logs. I
> need to see what data is in these backup logs. If there is a product that
> can do this can it apply the data from the logs or dump it to a file?
>
> Thanks.
>

read trn log backup files

What product is out there that can read a Transaction Backup file?
A restore was done but they didn't apply a couple of transaction logs. I
need to see what data is in these backup logs. If there is a product that
can do this can it apply the data from the logs or dump it to a file?
Thanks.I've listed some on my links page:
http://www.karaszi.com/SQLServer/links.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"AHartman" <Hoosbruin@.Kconline.com> wrote in message news:OS70VXD3HHA.212@.TK2MSFTNGP05.phx.g
bl...
> What product is out there that can read a Transaction Backup file?
> A restore was done but they didn't apply a couple of transaction logs. I
> need to see what data is in these backup logs. If there is a product that
> can do this can it apply the data from the logs or dump it to a file?
>
> Thanks.
>

read trn log backup files

What product is out there that can read a Transaction Backup file?
A restore was done but they didn't apply a couple of transaction logs. I
need to see what data is in these backup logs. If there is a product that
can do this can it apply the data from the logs or dump it to a file?
Thanks.I've listed some on my links page:
http://www.karaszi.com/SQLServer/links.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"AHartman" <Hoosbruin@.Kconline.com> wrote in message news:OS70VXD3HHA.212@.TK2MSFTNGP05.phx.gbl...
> What product is out there that can read a Transaction Backup file?
> A restore was done but they didn't apply a couple of transaction logs. I
> need to see what data is in these backup logs. If there is a product that
> can do this can it apply the data from the logs or dump it to a file?
>
> Thanks.
>sql

read transaction log

How can I read transaction log. I tried to open it in
notepad, but cannot recognize the words?
ThanksLog Explorer from www.lumigent.com
"Ann" <xiaowei.cao@.state.mn.us> wrote in message
news:2aaca01c39270$f27433c0$a601280a@.phx.gbl...
> How can I read transaction log. I tried to open it in
> notepad, but cannot recognize the words?
> Thanks

Read the transaction log (ldf) file. My first post ever :)

Hi!

The purpose is to se history of which user updated, inserted or deleted a row in the database.

Can't seem to find any publications from microsoft on how to parse and interpret the log file.

Any documentation on how the log file is structured?
Is it possible to obtain this information through the system views

I don't want to use triggers.

Thanks

Consider the use of a third-party application for this job. That is money that's well spent.

|||

Thanks for the reply.

I know there exist som applications that can read log files, like Lumigent Log Explorer.

But it would be nice with an freeware version

|||

If you really want to learn, here the docuemnt on basic level.. I found few months back very unexpectedly... Nice one....

But this document is not sufficient to start programing with Tx Log files.. As Frank says you can use the 3rd party tools.. there are lot of products available on the market...

https://www.blackhat.com/presentations/bh-usa-07/Fowler/Presentation/bh-usa-07-fowler.pdf

|||

J-A.G. wrote:

I know there exist som applications that can read log files, like Lumigent Log Explorer.

But it would be nice with an freeware version

TANSTAAFL

But in order to learn you can always use something like the undocumented

DBCC LOG (Northwind, -1)

|||

good frank!

This undocumented command works on sql2000?

|||

Yes it does. But as with all undocumented features the use is at your own risk.

|||Tks!

Monday, March 26, 2012

Read the database transaction log file ie LDF file

Hi,
I want to read the .LDF for a database without making that database offline.
.LDF file contains all the transactions in that database.
Is there any documented/undocumented approach?
Any help is appreciated.
Thanks
PushkarThere are various third-party tools that can help.
LogPI, Log Explorer, etc.
Recently I've been using Red Gate's tool quite a bit... I think it's a bit s
impler to use than the other available tools:
http://www.red-gate.com/sql/sql_log_rescue.htm
--
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Pushkar" <pushkartiwari@.gmail.com> wrote in message news:OOFQjIMqFHA.904@.TK
2MSFTNGP10.phx.gbl...
Hi,
I want to read the .LDF for a database without making that database offline.
.LDF file contains all the transactions in that database.
Is there any documented/undocumented approach?
Any help is appreciated.
Thanks
Pushkar|||Use a third party tool.
http://www.aspfaq.com/2449
"Pushkar" <pushkartiwari@.gmail.com> wrote in message
news:OOFQjIMqFHA.904@.TK2MSFTNGP10.phx.gbl...
Hi,
I want to read the .LDF for a database without making that database offline.
.LDF file contains all the transactions in that database.
Is there any documented/undocumented approach?
Any help is appreciated.
Thanks
Pushkar|||You can use the undocumented command DBCC LOG. See:
[url]http://www.sql-server-performance.com/ac_sql_server_2000_undocumented_dbcc.asp[/ur
l]
A better approach would be to use a third-party tool, such as
Lumigent Log Explorer, ApexSQL Log or Red-Gate SQL Log Rescue.
Razvan

read sql log files

hi,
There is anyway or tools that I could read sql log backup(.bak)files?
ThnakaI hopfully understand your question correct. I assume you want to see
history of your backup jobs and you use SQL Server 2005. If not, please let
me know.
Fire up SQL Server Management Studio.
Connect to your instance, expand SQL Server Agent and then expand Jobs.
Right click on the backup job and click View History.
To see about your jobs' last events, go to SQL Server Agent node in SSMS and
double click on the Job Activity Monitor.
--
Ekrem Önsoy
MCBDA, MCTS: SQL Server 2005, MCSD.Net, MCSE, MCT
"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23yg0ufW8HHA.5456@.TK2MSFTNGP05.phx.gbl...
> hi,
> There is anyway or tools that I could read sql log backup(.bak)files?
> Thnaka
>|||mecn,
I believe that you are asking to read the transaction logs, is that correct?
SQL Server itself does not provide a facility, but others sell software:
http://www.apexsql.com/sql_tools_log.asp
http://www.red-gate.com/products/SQL_Log_Rescue/index.htm - For SQL Server
2000, Free.
http://www.lumigent.com/Products/le_sql.html
Check it out.
RLF
"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23yg0ufW8HHA.5456@.TK2MSFTNGP05.phx.gbl...
> hi,
> There is anyway or tools that I could read sql log backup(.bak)files?
> Thnaka
>|||In article <#yg0ufW8HHA.5456@.TK2MSFTNGP05.phx.gbl>, mecn2002@.yahoo.com
says...
> hi,
> There is anyway or tools that I could read sql log backup(.bak)files?
> Thnaka
>
>
Lumigent Log Reader is excellent if a bit pricey. Also adds several
capabilities to your recovery processing.
--
Graham (Pete) Berry
PeteBerry@.Caltech.edusql

Read perfmon log into SQL table

Is there a way i can import the .blg perfmon counter log into a table for
reporting purposesUsing Performance (System) Monitor in Windows 2000 and 2003, you can save
the log to the text file. Then you can use Bulk Insert to copy the data to a
table. I don't remember for Win 2k, but in Win 2003 you can save it even
directly to a SQL table.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:#XqypYBfDHA.1888@.TK2MSFTNGP12.phx.gbl...
> Is there a way i can import the .blg perfmon counter log into a table for
> reporting purposes
>|||Since you have the perfmon file in binary format you can pull out the actual
counters you want as csv using win2k resource kit program relog.exe. Then
create a table with the desired structure and bcp it in, or do a DTS import.
If you are running on xp or 2003 you can have perfmon log straight to a sql
server database.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:#XqypYBfDHA.1888@.TK2MSFTNGP12.phx.gbl...
> Is there a way i can import the .blg perfmon counter log into a table for
> reporting purposes
>

read out transaction log

Hello!
is there a possibility to get all transactions between two dates out of
transaction log, an then inject this data into a new database? i need the
data from 01.09.2006 to 24.12.2006. the last full backup - witch is not
available - was before this time, so all changes must be in the transaction
log.
the structure is known and reproducable.
Database recovery mod is full.
Thank you!Hi Marcus
You can do this using the tools you have already mentioned in your previous
posts. If you have truncated the log then they will no longer be recoverable.
In your current situation it is probably be worthwhile opening a call with
PSS.
John
"Marcus Pink" wrote:
> Hello!
> is there a possibility to get all transactions between two dates out of
> transaction log, an then inject this data into a new database? i need the
> data from 01.09.2006 to 24.12.2006. the last full backup - witch is not
> available - was before this time, so all changes must be in the transaction
> log.
> the structure is known and reproducable.
>
> Database recovery mod is full.
> Thank you!
>
>|||Hi John,
the log file should not be truncated, but i've tried several programs with
no luck.
Is it possible to check if the file is truncated?
Open a call with PSS? Whats that? I don't know this.
Marcus
"John Bell" <jbellnewsposts@.hotmail.com> schrieb im Newsbeitrag
news:F94DB8AC-CFD3-48A3-B5F6-4DD57E85F8FF@.microsoft.com...
> Hi Marcus
> You can do this using the tools you have already mentioned in your
> previous
> posts. If you have truncated the log then they will no longer be
> recoverable.
> In your current situation it is probably be worthwhile opening a call with
> PSS.
> John
> "Marcus Pink" wrote:
>> Hello!
>> is there a possibility to get all transactions between two dates out of
>> transaction log, an then inject this data into a new database? i need the
>> data from 01.09.2006 to 24.12.2006. the last full backup - witch is not
>> available - was before this time, so all changes must be in the
>> transaction
>> log.
>> the structure is known and reproducable.
>>
>> Database recovery mod is full.
>> Thank you!
>>|||Hi Marcus
DBCC SQLPERF ( LOGSPACE ) will give you some idea of what is being used, but
it will not give you the detail you require. Using a program such as the
lumigent log explorer you should be able to browse what is in the log. A 600
MB file would take some time to process, but filtering on a very short date
range and specific tables may help.
PSS is Microsoft Product Support, raising an incident will cost you see
https://support.microsoft.com/oas/default.aspx?&c1=508&gprid=2852&
John
"Marcus Pink" wrote:
> Hi John,
> the log file should not be truncated, but i've tried several programs with
> no luck.
> Is it possible to check if the file is truncated?
> Open a call with PSS? Whats that? I don't know this.
>
> Marcus
> "John Bell" <jbellnewsposts@.hotmail.com> schrieb im Newsbeitrag
> news:F94DB8AC-CFD3-48A3-B5F6-4DD57E85F8FF@.microsoft.com...
> > Hi Marcus
> >
> > You can do this using the tools you have already mentioned in your
> > previous
> > posts. If you have truncated the log then they will no longer be
> > recoverable.
> >
> > In your current situation it is probably be worthwhile opening a call with
> > PSS.
> >
> > John
> >
> > "Marcus Pink" wrote:
> >
> >> Hello!
> >>
> >> is there a possibility to get all transactions between two dates out of
> >> transaction log, an then inject this data into a new database? i need the
> >> data from 01.09.2006 to 24.12.2006. the last full backup - witch is not
> >> available - was before this time, so all changes must be in the
> >> transaction
> >> log.
> >>
> >> the structure is known and reproducable.
> >>
> >>
> >> Database recovery mod is full.
> >>
> >> Thank you!
> >>
> >>
> >>
>
>

Friday, March 23, 2012

Read log files

hi,
how do i read the transaction log file. Actualy i've got a database given my some 1 else, we do not have the db diagrams and no relationship between the tables and no source code, can we find out that when the front end application updates the tables, wh
ich are the table where entries r made? I wanted to use that data futher?...
Check out Lumigent's "Log Explorer" product - it's built for performing log
analysis etc.
www.lumigent.com
Regards,
Greg Linwood
SQL Server MVP
"sim sim" <sim sim@.discussions.microsoft.com> wrote in message
news:73057BCA-FDEB-4D07-B5DA-40867DE76678@.microsoft.com...
> hi,
> how do i read the transaction log file. Actualy i've got a database given
my some 1 else, we do not have the db diagrams and no relationship between
the tables and no source code, can we find out that when the front end
application updates the tables, which are the table where entries r made? I
wanted to use that data futher?...
>
|||hi Greg,
thanks 4 the reply, but this site give a 3rd party software 2 do the same... can't we read the log file without this. or is there any way by which i can find which tables are getting updated by recent transactions.
regards,
"Greg Linwood" wrote:

> Check out Lumigent's "Log Explorer" product - it's built for performing log
> analysis etc.
> www.lumigent.com
> Regards,
> Greg Linwood
> SQL Server MVP
> "sim sim" <sim sim@.discussions.microsoft.com> wrote in message
> news:73057BCA-FDEB-4D07-B5DA-40867DE76678@.microsoft.com...
> my some 1 else, we do not have the db diagrams and no relationship between
> the tables and no source code, can we find out that when the front end
> application updates the tables, which are the table where entries r made? I
> wanted to use that data futher?...
>
>
|||You might consider running a Profiler trace to track application activity.
This can be saved to a table for subsequent analysis.
Hope this helps.
Dan Guzman
SQL Server MVP
"sim sim" <simsim@.discussions.microsoft.com> wrote in message
news:266C54C8-505E-46BF-8CFB-4C55C6838D40@.microsoft.com...
> hi Greg,
> thanks 4 the reply, but this site give a 3rd party software 2 do the
same... can't we read the log file without this. or is there any way by
which i can find which tables are getting updated by recent transactions.[vbcol=seagreen]
> regards,
>
> "Greg Linwood" wrote:
log[vbcol=seagreen]
given[vbcol=seagreen]
between[vbcol=seagreen]
made? I[vbcol=seagreen]
|||Hi Dan
Thanks a lot u'r suggestion was of great help. Can u suggest some site where i can get good help on making use of the SQL Profiler.
Regards
"Dan Guzman" wrote:

> You might consider running a Profiler trace to track application activity.
> This can be saved to a table for subsequent analysis.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "sim sim" <simsim@.discussions.microsoft.com> wrote in message
> news:266C54C8-505E-46BF-8CFB-4C55C6838D40@.microsoft.com...
> same... can't we read the log file without this. or is there any way by
> which i can find which tables are getting updated by recent transactions.
> log
> given
> between
> made? I
>
>
|||I suggest you start with the Books Online
<adminsql.chm::/ad_mon_perf_88c3.htm>. You can save the results to a table
for ad-hoc analysis. The events of interest here are the 'completed' events
for batches and RPCs. You can also add sp:statement completed if needed.
Hope this helps.
Dan Guzman
SQL Server MVP
"sim sim" <simsim@.discussions.microsoft.com> wrote in message
news:9BF8F3EE-D25B-4089-9E4D-9B34CB99BF69@.microsoft.com...
> Hi Dan
> Thanks a lot u'r suggestion was of great help. Can u suggest some site
where i can get good help on making use of the SQL Profiler.[vbcol=seagreen]
> Regards
>
> "Dan Guzman" wrote:
activity.[vbcol=seagreen]
the[vbcol=seagreen]
transactions.[vbcol=seagreen]
performing[vbcol=seagreen]
database[vbcol=seagreen]
end[vbcol=seagreen]

Read log files

hi,
how do i read the transaction log file. Actualy i've got a database given my some 1 else, we do not have the db diagrams and no relationship between the tables and no source code, can we find out that when the front end application updates the tables, which are the table where entries r made? I wanted to use that data futher?...Check out Lumigent's "Log Explorer" product - it's built for performing log
analysis etc.
www.lumigent.com
Regards,
Greg Linwood
SQL Server MVP
"sim sim" <sim sim@.discussions.microsoft.com> wrote in message
news:73057BCA-FDEB-4D07-B5DA-40867DE76678@.microsoft.com...
> hi,
> how do i read the transaction log file. Actualy i've got a database given
my some 1 else, we do not have the db diagrams and no relationship between
the tables and no source code, can we find out that when the front end
application updates the tables, which are the table where entries r made? I
wanted to use that data futher?...
>|||hi Greg,
thanks 4 the reply, but this site give a 3rd party software 2 do the same... can't we read the log file without this. or is there any way by which i can find which tables are getting updated by recent transactions.
regards,
"Greg Linwood" wrote:
> Check out Lumigent's "Log Explorer" product - it's built for performing log
> analysis etc.
> www.lumigent.com
> Regards,
> Greg Linwood
> SQL Server MVP
> "sim sim" <sim sim@.discussions.microsoft.com> wrote in message
> news:73057BCA-FDEB-4D07-B5DA-40867DE76678@.microsoft.com...
> > hi,
> >
> > how do i read the transaction log file. Actualy i've got a database given
> my some 1 else, we do not have the db diagrams and no relationship between
> the tables and no source code, can we find out that when the front end
> application updates the tables, which are the table where entries r made? I
> wanted to use that data futher?...
> >
> >
>
>|||You might consider running a Profiler trace to track application activity.
This can be saved to a table for subsequent analysis.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"sim sim" <simsim@.discussions.microsoft.com> wrote in message
news:266C54C8-505E-46BF-8CFB-4C55C6838D40@.microsoft.com...
> hi Greg,
> thanks 4 the reply, but this site give a 3rd party software 2 do the
same... can't we read the log file without this. or is there any way by
which i can find which tables are getting updated by recent transactions.
> regards,
>
> "Greg Linwood" wrote:
> > Check out Lumigent's "Log Explorer" product - it's built for performing
log
> > analysis etc.
> >
> > www.lumigent.com
> >
> > Regards,
> > Greg Linwood
> > SQL Server MVP
> >
> > "sim sim" <sim sim@.discussions.microsoft.com> wrote in message
> > news:73057BCA-FDEB-4D07-B5DA-40867DE76678@.microsoft.com...
> > > hi,
> > >
> > > how do i read the transaction log file. Actualy i've got a database
given
> > my some 1 else, we do not have the db diagrams and no relationship
between
> > the tables and no source code, can we find out that when the front end
> > application updates the tables, which are the table where entries r
made? I
> > wanted to use that data futher?...
> > >
> > >
> >
> >
> >|||Hi Dan
Thanks a lot u'r suggestion was of great help. Can u suggest some site where i can get good help on making use of the SQL Profiler.
Regards
"Dan Guzman" wrote:
> You might consider running a Profiler trace to track application activity.
> This can be saved to a table for subsequent analysis.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "sim sim" <simsim@.discussions.microsoft.com> wrote in message
> news:266C54C8-505E-46BF-8CFB-4C55C6838D40@.microsoft.com...
> > hi Greg,
> >
> > thanks 4 the reply, but this site give a 3rd party software 2 do the
> same... can't we read the log file without this. or is there any way by
> which i can find which tables are getting updated by recent transactions.
> >
> > regards,
> >
> >
> > "Greg Linwood" wrote:
> >
> > > Check out Lumigent's "Log Explorer" product - it's built for performing
> log
> > > analysis etc.
> > >
> > > www.lumigent.com
> > >
> > > Regards,
> > > Greg Linwood
> > > SQL Server MVP
> > >
> > > "sim sim" <sim sim@.discussions.microsoft.com> wrote in message
> > > news:73057BCA-FDEB-4D07-B5DA-40867DE76678@.microsoft.com...
> > > > hi,
> > > >
> > > > how do i read the transaction log file. Actualy i've got a database
> given
> > > my some 1 else, we do not have the db diagrams and no relationship
> between
> > > the tables and no source code, can we find out that when the front end
> > > application updates the tables, which are the table where entries r
> made? I
> > > wanted to use that data futher?...
> > > >
> > > >
> > >
> > >
> > >
>
>|||I suggest you start with the Books Online
<adminsql.chm::/ad_mon_perf_88c3.htm>. You can save the results to a table
for ad-hoc analysis. The events of interest here are the 'completed' events
for batches and RPCs. You can also add sp:statement completed if needed.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"sim sim" <simsim@.discussions.microsoft.com> wrote in message
news:9BF8F3EE-D25B-4089-9E4D-9B34CB99BF69@.microsoft.com...
> Hi Dan
> Thanks a lot u'r suggestion was of great help. Can u suggest some site
where i can get good help on making use of the SQL Profiler.
> Regards
>
> "Dan Guzman" wrote:
> > You might consider running a Profiler trace to track application
activity.
> > This can be saved to a table for subsequent analysis.
> >
> > --
> > Hope this helps.
> >
> > Dan Guzman
> > SQL Server MVP
> >
> > "sim sim" <simsim@.discussions.microsoft.com> wrote in message
> > news:266C54C8-505E-46BF-8CFB-4C55C6838D40@.microsoft.com...
> > > hi Greg,
> > >
> > > thanks 4 the reply, but this site give a 3rd party software 2 do
the
> > same... can't we read the log file without this. or is there any way by
> > which i can find which tables are getting updated by recent
transactions.
> > >
> > > regards,
> > >
> > >
> > > "Greg Linwood" wrote:
> > >
> > > > Check out Lumigent's "Log Explorer" product - it's built for
performing
> > log
> > > > analysis etc.
> > > >
> > > > www.lumigent.com
> > > >
> > > > Regards,
> > > > Greg Linwood
> > > > SQL Server MVP
> > > >
> > > > "sim sim" <sim sim@.discussions.microsoft.com> wrote in message
> > > > news:73057BCA-FDEB-4D07-B5DA-40867DE76678@.microsoft.com...
> > > > > hi,
> > > > >
> > > > > how do i read the transaction log file. Actualy i've got a
database
> > given
> > > > my some 1 else, we do not have the db diagrams and no relationship
> > between
> > > > the tables and no source code, can we find out that when the front
end
> > > > application updates the tables, which are the table where entries r
> > made? I
> > > > wanted to use that data futher?...
> > > > >
> > > > >
> > > >
> > > >
> > > >
> >
> >
> >

Read log files

hi,
how do i read the transaction log file. Actualy i've got a database given my
some 1 else, we do not have the db diagrams and no relationship between the
tables and no source code, can we find out that when the front end applicat
ion updates the tables, wh
ich are the table where entries r made? I wanted to use that data futher?...Check out Lumigent's "Log Explorer" product - it's built for performing log
analysis etc.
www.lumigent.com
Regards,
Greg Linwood
SQL Server MVP
"sim sim" <sim sim@.discussions.microsoft.com> wrote in message
news:73057BCA-FDEB-4D07-B5DA-40867DE76678@.microsoft.com...
> hi,
> how do i read the transaction log file. Actualy i've got a database given
my some 1 else, we do not have the db diagrams and no relationship between
the tables and no source code, can we find out that when the front end
application updates the tables, which are the table where entries r made? I
wanted to use that data futher?...
>|||hi Greg,
thanks 4 the reply, but this site give a 3rd party software 2 do the same...
can't we read the log file without this. or is there any way by which i can
find which tables are getting updated by recent transactions.
regards,
"Greg Linwood" wrote:

> Check out Lumigent's "Log Explorer" product - it's built for performing lo
g
> analysis etc.
> www.lumigent.com
> Regards,
> Greg Linwood
> SQL Server MVP
> "sim sim" <sim sim@.discussions.microsoft.com> wrote in message
> news:73057BCA-FDEB-4D07-B5DA-40867DE76678@.microsoft.com...
> my some 1 else, we do not have the db diagrams and no relationship between
> the tables and no source code, can we find out that when the front end
> application updates the tables, which are the table where entries r made?
I
> wanted to use that data futher?...
>
>|||You might consider running a Profiler trace to track application activity.
This can be saved to a table for subsequent analysis.
Hope this helps.
Dan Guzman
SQL Server MVP
"sim sim" <simsim@.discussions.microsoft.com> wrote in message
news:266C54C8-505E-46BF-8CFB-4C55C6838D40@.microsoft.com...
> hi Greg,
> thanks 4 the reply, but this site give a 3rd party software 2 do the
same... can't we read the log file without this. or is there any way by
which i can find which tables are getting updated by recent transactions.[vbcol=seagreen]
> regards,
>
> "Greg Linwood" wrote:
>
log[vbcol=seagreen]
given[vbcol=seagreen]
between[vbcol=seagreen]
made? I[vbcol=seagreen]|||Hi Dan
Thanks a lot u'r suggestion was of great help. Can u suggest some site where
i can get good help on making use of the SQL Profiler.
Regards
"Dan Guzman" wrote:

> You might consider running a Profiler trace to track application activity.
> This can be saved to a table for subsequent analysis.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "sim sim" <simsim@.discussions.microsoft.com> wrote in message
> news:266C54C8-505E-46BF-8CFB-4C55C6838D40@.microsoft.com...
> same... can't we read the log file without this. or is there any way by
> which i can find which tables are getting updated by recent transactions.
> log
> given
> between
> made? I
>
>|||I suggest you start with the Books Online
<adminsql.chm::/ad_mon_perf_88c3.htm>. You can save the results to a table
for ad-hoc analysis. The events of interest here are the 'completed' events
for batches and RPCs. You can also add sp:statement completed if needed.
Hope this helps.
Dan Guzman
SQL Server MVP
"sim sim" <simsim@.discussions.microsoft.com> wrote in message
news:9BF8F3EE-D25B-4089-9E4D-9B34CB99BF69@.microsoft.com...
> Hi Dan
> Thanks a lot u'r suggestion was of great help. Can u suggest some site
where i can get good help on making use of the SQL Profiler.[vbcol=seagreen]
> Regards
>
> "Dan Guzman" wrote:
>
activity.[vbcol=seagreen]
the[vbcol=seagreen]
transactions.[vbcol=seagreen]
performing[vbcol=seagreen]
database[vbcol=seagreen]
end[vbcol=seagreen]sql

READ LDF FILES

I would like to know is it possible and how to read LOG files with SQL-DMO?

My clients would like to know who is doing what and when. Actually I would like to trace table activites these are DELETES, UPDATES & INSERTS only. Also I know that it is possible to do it with triggers & jobs by creating new tables but imagine you have a database with size greater then 10 GB. It wouldn't be a good solution at all.

Thanks in advance,
SQL-DMO does not have that capability.

However, SMO has a namespace, which allows you do to live capture of trace data. See the Microsoft.SqlServer.Management.Trace namespace in Books Online.

However that is not reading LDF files, but starting a trace. If you want to read log files there are various 3rd party product out there that offer that capability.

Read information from transaction log

Hi,
I am a beginner in SQL/RDBMS and learning the different nuances of the SQL
Server. I know that all activities in a database are stored in a transaction
log and I can see where the file is stored. My question is how do I read any
information from a transaction log?
For example I delete a row manually in the Enterprise Manager (which I
should not have deleted), how do I Rollback that delete or how do I read the
transaction log to see what has happened and reverse that action.
Any help will be highly appreciated.
Thanks in advance
Aditya.There isn't a documented method to read transaction log data. You can get
some info by using undocumented commands like DBCC LOG. A better method is
with a third party tool like Lumigent's Log Explorer www.lumigent.com.
quote:

> For example I delete a row manually in the Enterprise Manager (which I
> should not have deleted), how do I Rollback that delete or how do I read

the
quote:

> transaction log to see what has happened and reverse that action.

If you are running in the FULL or BULK_LOGGED recovery model, you can backup
the current transaction log, restore the database (to a different name if
you want to keep the existing database intact) and then apply your
transaction log backups up to the point of the delete. See the Books Online
for more information.
Hope this helps.
Dan Guzman
SQL Server MVP
"Aditya" <grafica@.md2.vsnl.net.in> wrote in message
news:O2CkJSq4DHA.2888@.tk2msftngp13.phx.gbl...
quote:

> Hi,
> I am a beginner in SQL/RDBMS and learning the different nuances of the SQL
> Server. I know that all activities in a database are stored in a

transaction
quote:

> log and I can see where the file is stored. My question is how do I read

any
quote:

> information from a transaction log?
> For example I delete a row manually in the Enterprise Manager (which I
> should not have deleted), how do I Rollback that delete or how do I read

the
quote:

> transaction log to see what has happened and reverse that action.
> Any help will be highly appreciated.
> Thanks in advance
> Aditya.
>
|||Hi Aditya
Dan answered your question about reading the log.
For rollback, there is no way to do it from Enterprise Manager. Each insert,
update and delete is auto-committed.
The only alternative is to use a query tool like query analyzer, and use a
BEGIN TRANSACTION before any changes, and then if you're satisified with the
change you can COMMIT TRANSACTION, if you're not, you can ROLLBACK
TRANSACTION.
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Aditya" <grafica@.md2.vsnl.net.in> wrote in message
news:O2CkJSq4DHA.2888@.tk2msftngp13.phx.gbl...
quote:

> Hi,
> I am a beginner in SQL/RDBMS and learning the different nuances of the SQL
> Server. I know that all activities in a database are stored in a

transaction
quote:

> log and I can see where the file is stored. My question is how do I read

any
quote:

> information from a transaction log?
> For example I delete a row manually in the Enterprise Manager (which I
> should not have deleted), how do I Rollback that delete or how do I read

the
quote:

> transaction log to see what has happened and reverse that action.
> Any help will be highly appreciated.
> Thanks in advance
> Aditya.
>
|||Just to comment on both Dan and Kalen's posts, Log Explorer will allow you
to generate SQL commands to redo or undo a specific transaction. That comes
in handy sometimes when developers have direct access to production
databases.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
CareerBuilder.com
"Aditya" <grafica@.md2.vsnl.net.in> wrote in message
news:O2CkJSq4DHA.2888@.tk2msftngp13.phx.gbl...
quote:

> Hi,
> I am a beginner in SQL/RDBMS and learning the different nuances of the SQL
> Server. I know that all activities in a database are stored in a

transaction
quote:

> log and I can see where the file is stored. My question is how do I read

any
quote:

> information from a transaction log?
> For example I delete a row manually in the Enterprise Manager (which I
> should not have deleted), how do I Rollback that delete or how do I read

the
quote:

> transaction log to see what has happened and reverse that action.
> Any help will be highly appreciated.
> Thanks in advance
> Aditya.
>
|||Hi,
Thank you all for your posts. I will try them and get back if I have any
other queries.
Thanks again.
Aditya.
"Aditya" <grafica@.md2.vsnl.net.in> wrote in message
news:O2CkJSq4DHA.2888@.tk2msftngp13.phx.gbl...
quote:

> Hi,
> I am a beginner in SQL/RDBMS and learning the different nuances of the SQL
> Server. I know that all activities in a database are stored in a

transaction
quote:

> log and I can see where the file is stored. My question is how do I read

any
quote:

> information from a transaction log?
> For example I delete a row manually in the Enterprise Manager (which I
> should not have deleted), how do I Rollback that delete or how do I read

the
quote:

> transaction log to see what has happened and reverse that action.
> Any help will be highly appreciated.
> Thanks in advance
> Aditya.
>
|||There is also LogPi: http://www.logpi.com/
--
Mike Epprecht, Microsoft SQL Server MVP
Epprecht Consulting (PTY) LTD
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike@.NOSPAMepprecht.net
Specialist SQL Server Solutions and Consulting
"Aditya" <grafica@.md2.vsnl.net.in> wrote in message
news:%23KzpPsz4DHA.2696@.TK2MSFTNGP09.phx.gbl...
quote:

> Hi,
> Thank you all for your posts. I will try them and get back if I have any
> other queries.
> Thanks again.
> Aditya.
> "Aditya" <grafica@.md2.vsnl.net.in> wrote in message
> news:O2CkJSq4DHA.2888@.tk2msftngp13.phx.gbl...
SQL[QUOTE]
> transaction
> any
> the
>
|||Hi,
Still I like to known the internal format from the transactionlog. I can't
find it on the internet.
Greetz.
"Mike Epprecht [SQL Server MVP]" <mike@.NOSPAMepprecht.net> wrote in message
news:uVhuhO64DHA.2496@.TK2MSFTNGP09.phx.gbl...
quote:

> There is also LogPi: http://www.logpi.com/
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Epprecht Consulting (PTY) LTD
> Johannesburg, South Africa
> Mobile: +27-82-552-0268
> IM: mike@.NOSPAMepprecht.net
> Specialist SQL Server Solutions and Consulting
> "Aditya" <grafica@.md2.vsnl.net.in> wrote in message
> news:%23KzpPsz4DHA.2696@.TK2MSFTNGP09.phx.gbl...
> SQL
read[QUOTE]
read[QUOTE]
>
|||It is not published. Possibly, if you sign such an agreement that these
vendors has signed with MS, you can get your hands on it. Assuming that such
an agreement does exists for the structure of the t-log, of course. These
vendors might have reverse-engineered the log structure the hard way.
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Renegade" <Nospam-123-123@.hotmail.com> wrote in message
news:40180e6c$0$333$e4fe514c@.news.xs4all.nl...
quote:

> Hi,
> Still I like to known the internal format from the transactionlog. I can't
> find it on the internet.
> Greetz.
>
sql

Read information from transaction log

Hi,
I am a beginner in SQL/RDBMS and learning the different nuances of the SQL
Server. I know that all activities in a database are stored in a transaction
log and I can see where the file is stored. My question is how do I read any
information from a transaction log?
For example I delete a row manually in the Enterprise Manager (which I
should not have deleted), how do I Rollback that delete or how do I read the
transaction log to see what has happened and reverse that action.
Any help will be highly appreciated.
Thanks in advance
Aditya.There isn't a documented method to read transaction log data. You can get
some info by using undocumented commands like DBCC LOG. A better method is
with a third party tool like Lumigent's Log Explorer www.lumigent.com.
> For example I delete a row manually in the Enterprise Manager (which I
> should not have deleted), how do I Rollback that delete or how do I read
the
> transaction log to see what has happened and reverse that action.
If you are running in the FULL or BULK_LOGGED recovery model, you can backup
the current transaction log, restore the database (to a different name if
you want to keep the existing database intact) and then apply your
transaction log backups up to the point of the delete. See the Books Online
for more information.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Aditya" <grafica@.md2.vsnl.net.in> wrote in message
news:O2CkJSq4DHA.2888@.tk2msftngp13.phx.gbl...
> Hi,
> I am a beginner in SQL/RDBMS and learning the different nuances of the SQL
> Server. I know that all activities in a database are stored in a
transaction
> log and I can see where the file is stored. My question is how do I read
any
> information from a transaction log?
> For example I delete a row manually in the Enterprise Manager (which I
> should not have deleted), how do I Rollback that delete or how do I read
the
> transaction log to see what has happened and reverse that action.
> Any help will be highly appreciated.
> Thanks in advance
> Aditya.
>|||Hi Aditya
Dan answered your question about reading the log.
For rollback, there is no way to do it from Enterprise Manager. Each insert,
update and delete is auto-committed.
The only alternative is to use a query tool like query analyzer, and use a
BEGIN TRANSACTION before any changes, and then if you're satisified with the
change you can COMMIT TRANSACTION, if you're not, you can ROLLBACK
TRANSACTION.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Aditya" <grafica@.md2.vsnl.net.in> wrote in message
news:O2CkJSq4DHA.2888@.tk2msftngp13.phx.gbl...
> Hi,
> I am a beginner in SQL/RDBMS and learning the different nuances of the SQL
> Server. I know that all activities in a database are stored in a
transaction
> log and I can see where the file is stored. My question is how do I read
any
> information from a transaction log?
> For example I delete a row manually in the Enterprise Manager (which I
> should not have deleted), how do I Rollback that delete or how do I read
the
> transaction log to see what has happened and reverse that action.
> Any help will be highly appreciated.
> Thanks in advance
> Aditya.
>|||Just to comment on both Dan and Kalen's posts, Log Explorer will allow you
to generate SQL commands to redo or undo a specific transaction. That comes
in handy sometimes when developers have direct access to production
databases. :)
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
CareerBuilder.com
"Aditya" <grafica@.md2.vsnl.net.in> wrote in message
news:O2CkJSq4DHA.2888@.tk2msftngp13.phx.gbl...
> Hi,
> I am a beginner in SQL/RDBMS and learning the different nuances of the SQL
> Server. I know that all activities in a database are stored in a
transaction
> log and I can see where the file is stored. My question is how do I read
any
> information from a transaction log?
> For example I delete a row manually in the Enterprise Manager (which I
> should not have deleted), how do I Rollback that delete or how do I read
the
> transaction log to see what has happened and reverse that action.
> Any help will be highly appreciated.
> Thanks in advance
> Aditya.
>|||Hi,
Thank you all for your posts. I will try them and get back if I have any
other queries.
Thanks again.
Aditya.
"Aditya" <grafica@.md2.vsnl.net.in> wrote in message
news:O2CkJSq4DHA.2888@.tk2msftngp13.phx.gbl...
> Hi,
> I am a beginner in SQL/RDBMS and learning the different nuances of the SQL
> Server. I know that all activities in a database are stored in a
transaction
> log and I can see where the file is stored. My question is how do I read
any
> information from a transaction log?
> For example I delete a row manually in the Enterprise Manager (which I
> should not have deleted), how do I Rollback that delete or how do I read
the
> transaction log to see what has happened and reverse that action.
> Any help will be highly appreciated.
> Thanks in advance
> Aditya.
>|||There is also LogPi: http://www.logpi.com/
--
--
Mike Epprecht, Microsoft SQL Server MVP
Epprecht Consulting (PTY) LTD
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike@.NOSPAMepprecht.net
Specialist SQL Server Solutions and Consulting
"Aditya" <grafica@.md2.vsnl.net.in> wrote in message
news:%23KzpPsz4DHA.2696@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Thank you all for your posts. I will try them and get back if I have any
> other queries.
> Thanks again.
> Aditya.
> "Aditya" <grafica@.md2.vsnl.net.in> wrote in message
> news:O2CkJSq4DHA.2888@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > I am a beginner in SQL/RDBMS and learning the different nuances of the
SQL
> > Server. I know that all activities in a database are stored in a
> transaction
> > log and I can see where the file is stored. My question is how do I read
> any
> > information from a transaction log?
> >
> > For example I delete a row manually in the Enterprise Manager (which I
> > should not have deleted), how do I Rollback that delete or how do I read
> the
> > transaction log to see what has happened and reverse that action.
> >
> > Any help will be highly appreciated.
> >
> > Thanks in advance
> > Aditya.
> >
> >
>|||Hi,
Still I like to known the internal format from the transactionlog. I can't
find it on the internet.
Greetz.
"Mike Epprecht [SQL Server MVP]" <mike@.NOSPAMepprecht.net> wrote in message
news:uVhuhO64DHA.2496@.TK2MSFTNGP09.phx.gbl...
> There is also LogPi: http://www.logpi.com/
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Epprecht Consulting (PTY) LTD
> Johannesburg, South Africa
> Mobile: +27-82-552-0268
> IM: mike@.NOSPAMepprecht.net
> Specialist SQL Server Solutions and Consulting
> "Aditya" <grafica@.md2.vsnl.net.in> wrote in message
> news:%23KzpPsz4DHA.2696@.TK2MSFTNGP09.phx.gbl...
> > Hi,
> >
> > Thank you all for your posts. I will try them and get back if I have any
> > other queries.
> >
> > Thanks again.
> > Aditya.
> >
> > "Aditya" <grafica@.md2.vsnl.net.in> wrote in message
> > news:O2CkJSq4DHA.2888@.tk2msftngp13.phx.gbl...
> > > Hi,
> > >
> > > I am a beginner in SQL/RDBMS and learning the different nuances of the
> SQL
> > > Server. I know that all activities in a database are stored in a
> > transaction
> > > log and I can see where the file is stored. My question is how do I
read
> > any
> > > information from a transaction log?
> > >
> > > For example I delete a row manually in the Enterprise Manager (which I
> > > should not have deleted), how do I Rollback that delete or how do I
read
> > the
> > > transaction log to see what has happened and reverse that action.
> > >
> > > Any help will be highly appreciated.
> > >
> > > Thanks in advance
> > > Aditya.
> > >
> > >
> >
> >
>|||It is not published. Possibly, if you sign such an agreement that these
vendors has signed with MS, you can get your hands on it. Assuming that such
an agreement does exists for the structure of the t-log, of course. These
vendors might have reverse-engineered the log structure the hard way.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Renegade" <Nospam-123-123@.hotmail.com> wrote in message
news:40180e6c$0$333$e4fe514c@.news.xs4all.nl...
> Hi,
> Still I like to known the internal format from the transactionlog. I can't
> find it on the internet.
> Greetz.
>

read from transaction log

Hi,
I have transaction log backup every hour. Is there any way I can view the
transaction log to see what changes are done in past hour? ThanksThere are some third party tools that can read the log. The most
known is log Explorer from lumigent (www.lumigent.com).
Adi
On Feb 5, 9:54 pm, Jen <J...@.discussions.microsoft.com> wrote:
> Hi,
> I have transaction log backup every hour. Is there any way I can view the
> transaction log to see what changes are done in past hour? Thanks|||http://sqlserver2000.databases.aspfaq.com/how-do-i-recover-data-from-sql-server-s-log-files.html
Andrew J. Kelly SQL MVP
"Jen" <Jen@.discussions.microsoft.com> wrote in message
news:FC8333C5-00BC-41D7-8CC4-67F71DC5FC48@.microsoft.com...
> Hi,
> I have transaction log backup every hour. Is there any way I can view the
> transaction log to see what changes are done in past hour? Thanks

read from transaction log

Hi,
I have transaction log backup every hour. Is there any way I can view the
transaction log to see what changes are done in past hour? ThanksThere are some third party tools that can read the log. The most
known is log Explorer from lumigent (www.lumigent.com).
Adi
On Feb 5, 9:54 pm, Jen <J...@.discussions.microsoft.com> wrote:
> Hi,
> I have transaction log backup every hour. Is there any way I can view the
> transaction log to see what changes are done in past hour? Thanks|||http://sqlserver2000.databases.aspf...
log-files.html
Andrew J. Kelly SQL MVP
"Jen" <Jen@.discussions.microsoft.com> wrote in message
news:FC8333C5-00BC-41D7-8CC4-67F71DC5FC48@.microsoft.com...
> Hi,
> I have transaction log backup every hour. Is there any way I can view the
> transaction log to see what changes are done in past hour? Thanks