Re: .ldf files

From: "Kalen Delaney" <replies@xxxxxxxxxxxxxxxxxxxxx>
Date: Wed, 16 May 2007 15:44:14 -0700

Yes, this is most likely your transaction log, and it is not intended to be
analyzable. It is for SQL Server's own internal purposes. There are some 3rd
party tools available which can analyze the contents, such as

http://www.red-gate.com/products/SQL_Log_Rescue/

and

http://www.lumigent.com/products/le_sql.html

--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com

"mfm" <mfm@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F937D3DE-463A-45F8-9FC6-CB78605552FD@xxxxxxxxxxxxxxxx

Is the .ldf file the tranasction log, and if so,
How can I analyze the contents of the .ldf file?

Prev by Date: Re: Thousands of Login failed for user 'sa'
Next by Date: Re: Problem with SQL Server 2005 Express Edition
Previous by thread: Decryption within an application
Next by thread: Re: .ldf files
Index(es):
- Date
- Thread

Relevant Pages

Re: When should one rebuild an index?
... from internal Oracle resources is the same. ... I see no part of this doc suggesting ANALYZE being useless in determining index rebuild. ... Knock yourself out explaining whether this index should or should not be rebuilt based on the information generated by ANALYZE. ... SQL> ANALYZE INDEX ix_test VALIDATE STRUCTURE; ...
(comp.databases.oracle.server)
Dependencies and invalidations.
... In Oracle RDBMS 10.2 it is practically impossible to invalidate a PL/SQL ... create table emp1 as select * from emp; ... analyze table emp1 compute statistics for table for all indexed columns; ... SQL> create table emp1 as select * from emp; ...
(comp.databases.oracle.server)
Re: When should one rebuild an index?
... None of us make a dollar if you take our advice. ... that your database will benefit from an index rebuild. ... I see no part of this doc suggesting ANALYZE being useless in determining ... SQL> ANALYZE INDEX ix_test VALIDATE STRUCTURE; ...
(comp.databases.oracle.server)
Re: A potential bug (infinite loop) in Oracle: querying v$access
... SQL> CONNECT / AS SYSDBA ... Insufficient privileges to analyze an object in Fixed Ob ... I found Metalink doc ID 272479.1, ...
(comp.databases.oracle.server)
Oracle Optmizer does not use the right index (Oracle 9.2.0.6)
... SQL> create index tab1ind1 on tab1 ... SQL> analyze table tab1 compute statistics; ... Execution Plan ... Should be using index tab1ind1. ...
(comp.databases.oracle.server)