What's is a .LDf file? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

What's is a .LDf file?

Author

Topic

mbevon
Starting Member

41 Posts

Posted - 2002-07-23 : 09:06:15

What's is a .LDf file?
How could i view it's contents?

Thanks
Marls

andre
Constraint Violating Yak Guru

259 Posts

Posted - 2002-07-23 : 09:07:27

An LDF file is the transaction log file.

I believe you can view it by using a third-party tool like Log Explorer, which has been advertised on this site.

sterobhun
Starting Member

12 Posts

Posted - 2002-07-23 : 10:19:21

You can also use DBCC LOG to show the contents. The format is:

 dbcc log ([dbid [,{0|1|2|3|4} [,['lsn','x:y:z'] | ['numrecs',num] | ['xactid','x:y'] | ['extent','x:y'] | ['pageid','x:y'] | ['objid',{x,'y'}] | ['logrecs',{'lop'|op}...] | ['output',x,['filename','x']] ...]]] )

The first parameter is the database name, and the next specifies the style and amount of detail returned from the log. Any further parameters are used to filter the data returned.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources