Where to find log files in SQL server? - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

Where to find log files in SQL server?

Where to find log files in SQL server?# Database - 数据库

k*r2005-03-24 08:03

1 楼

For example, I delete a table then I want to look up the log files for the
deletion. Thanks.

t*s2005-03-24 08:03

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*r2005-03-24 08:03

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*n2005-03-24 08:03

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*s2005-03-24 08:03

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*r2005-03-24 08:03

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*r2005-03-24 08:03

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*n2005-03-24 08:03

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*r2005-03-24 08:03

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