Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2006
    Posts
    3

    Unhappy Unanswered: How to read active log file

    I am programming to read read sqlserver log file without shutdowning sqlserver. However it is said that the file is used by another process which I believe is sqlserver.
    Is there any way to open log file without shutdowning server? I know that Log Explorer can read online log file. But I do not know the technology they are using.

  2. #2
    Join Date
    Apr 2006
    Posts
    3
    Any help is very appreciated.

  3. #3
    Join Date
    Apr 2006
    Posts
    3
    I also know that 'dbcc log' and 'select * from ::fn_dblog(null,null)' can list log data. But I do not want to connect to sqlserver. I just want to open the log file and read the data from the log file directly. Thanks.

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Why? There are ways you can do this, but there are so problems to work around that it probably isn't worth the effort when there are so many easier ways to achieve the same results.

    -PatP

Posting Permissions

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