For example, I delete a table then I want to look up the log files for the deletion. Thanks.
t*s
2 楼
is MS SQL Server? if yes, then \SQLHome\MSSQL\LOG\ERRORLOG
【在 k******r 的大作中提到】 : For example, I delete a table then I want to look up the log files for the : deletion. Thanks.
k*r
3 楼
Yes, it is MS SQL server. But I couldn't find directory ERRORLOG(I assume it is a directory) under LOG. I guess maybe I need configure the SQL server somehow? Thanks for your information!
【在 t*****s 的大作中提到】 : is MS SQL Server? : if yes, then \SQLHome\MSSQL\LOG\ERRORLOG
s*n
4 楼
All I know is that SQL Server's log file is for data recovery purpose. What do u mean when u say "look up"?
【在 k******r 的大作中提到】 : For example, I delete a table then I want to look up the log files for the : deletion. Thanks.
t*s
5 楼
sorry, ERRORLOG is a file without extension
【在 k******r 的大作中提到】 : Yes, it is MS SQL server. But I couldn't find directory ERRORLOG(I assume it : is a directory) under LOG. I guess maybe I need configure the SQL server : somehow? Thanks for your information!
k*r
6 楼
Thanks for your reply. Actually, I am fixing a bug with database for the client. I have been working on the bug for three days but I couldn't find any problem with the program. Yesterday, all of sudden, I realized that most likely there was nothing wrong with my program and instead probably the customers modified the database manually. So I wanted to look up log files to monitor any changes made by customers. I have never done this before so I was asking how to do that.
【在 s******n 的大作中提到】 : All I know is that SQL Server's log file is for data recovery purpose. : What do u mean when u say "look up"?
k*r
7 楼
Now I know where those log files are located but I don't know how to open them. Any idea? Thanks.
any to was the
【在 k******r 的大作中提到】 : Thanks for your reply. Actually, I am fixing a bug with database for the : client. I have been working on the bug for three days but I couldn't find any : problem with the program. Yesterday, all of sudden, I realized that most : likely there was nothing wrong with my program and instead probably the : customers modified the database manually. So I wanted to look up log files to : monitor any changes made by customers. I have never done this before so I was : asking how to do that.
s*n
8 楼
Basically u r intested in "audit". The log file won't be easy to look into, but there are tools out there that can help u do that. One of them is as follows: http://www.sql-server-performance.com/lockwoodtech_log_navigator_spotlight.asp Btw, an earlier post told u about the errorlog, which is not the log u r looking for. The right one is in ....\mssql\data\[database name]_log.ldf
【在 k******r 的大作中提到】 : Now I know where those log files are located but I don't know how to open : them. Any idea? Thanks. : : any : to : was : the
k*r
9 楼
Super! Thank you very much! Can this tool also work with Sybase transaction log?
【在 s******n 的大作中提到】 : Basically u r intested in "audit". The log file won't be easy to look into, : but there are tools out there that can help u do that. One of them is as : follows: : http://www.sql-server-performance.com/lockwoodtech_log_navigator_spotlight.asp : Btw, an earlier post told u about the errorlog, which is not the log u r : looking for. The right one is in ....\mssql\data\[database name]_log.ldf