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.Any help is very appreciated.|||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.|||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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment