k******r 发帖数: 2300 | 1 For example, I delete a table then I want to look up the log files for the
deletion. Thanks. |
t*****s 发帖数: 124 | 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 发帖数: 2300 | 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 发帖数: 45 | 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 发帖数: 124 | 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 发帖数: 2300 | 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 发帖数: 2300 | 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 发帖数: 45 | 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 发帖数: 2300 | 9 Super! Thank you very much! Can this tool also work with Sybase transaction
log?
http://www.sql-server-performance.com/lockwoodtech_log_navigator_spotlight.asp
find
files
I
【在 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
|