Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2002
    Location
    india
    Posts
    3

    Thumbs up Unanswered: can i read ldf file of 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 file
    Last edited by sharmaanil20; 12-03-02 at 03:42.

  2. #2
    Join Date
    Jul 2002
    Location
    India
    Posts
    13
    pls be more specific. what is a ldf file.

    Balaji

  3. #3
    Join Date
    Oct 2002
    Posts
    369

    Post Re: can i read ldf file of sql server

    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}.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •