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
|
