Tuesday, February 14, 2012

can i read ldf file in sql server

Is there is any way to read ldf file in sql server.
While creating database in sql server it automatically create 2 files
one is.mdf which is data file and another is .ldf which is log file.
I wann to read this .ldf filepls be more specific. what is a ldf file.

:(|||RE: Q1 Is there is any way to read ldf file in sql server?

While creating database in sql server it automatically create 2 files
one is.mdf which is data file and another is .ldf which is log file.
Q2 I want to read this .ldf file

A1 Yes.

A2 For user purposes it would be exceedingly rare to need or want to do so (or have any particular reason to). DBA troubleshooting and development efforts are the main reasons to want to read Log files directly. If you are still curious, there is a third party tool (Lumigent Log Explorer), and dbcc Log (ala ver 6.x) still works as well e.g.{dbcc Log (Pubs), or optinally use a result set type parameter, but the sybase type multiparameter form is no longer supported}.

No comments:

Post a Comment