SQL Server Log file location - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

SQL Server Log file location

Author

Topic

elwoos
Master Smack Fu Yak Hacker

2052 Posts

Posted - 2005-08-31 : 05:01:45

Does anyone know where I can find the SQL server log files (for SQL server 7) - I don't mean the transaction logs. Will it cause problems if I move/delete them?

thanks

steve

Alright Brain, you don't like me, and I don't like you. But lets just do this, and I can get back to killing you with beer.

Kristen
Test

22859 Posts

Posted - 2005-08-31 : 05:17:45

Here they are in

X:\MSSQL\LOG

I don't think you can delete the current one, 'coz its in use. But there is a system SProc to "cycle" them (or stop/start SQL). Deleting the old ones does no harm.

If you want to do a File Search to lcoate yours I have:

ERRORLOG
ERRORLOG.1
ERRORLOG.2
etc
SQLAGENT.OUT
SQLAGENT.1
SQLAGENT.2
etc.

You might also have

SQLDump9999.txt
SQLDump9999.mdmp

which are worth cleaning up.

Kristen

elwoos
Master Smack Fu Yak Hacker

2052 Posts

Posted - 2005-08-31 : 05:29:21

cheers Kristen

steve

Alright Brain, you don't like me, and I don't like you. But lets just do this, and I can get back to killing you with beer.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources