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