Attempts to stop trace crash server

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)

Attempts to stop trace crash server

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-03-18 : 08:01:43

Jim writes "A former DBA added an Audit trace to our development server which has been filling up available disk space. I have identified the trace...

SELECT * FROM :: fn_trace_getinfo(default)
1 1 6
1 2 F:\Program Files\Microsoft SQL Server\MSSQL\Data\audittrace_20050317085321
1 3 200
1 4 NULL
1 5 1

I am unable to stop and delete it executing the following...
exec sp_trace_setstatus 1,0
go
exec sp_trace_setstatus 1,2
go
Crashes the server!?

Is there another method to kill this trace?

Thanks, Jim"

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2005-03-28 : 02:46:38

quote:
Originally posted by AskSQLTeam

Jim writes "A former DBA added an Audit trace to our development server which has been filling up available disk space. I have identified the trace...

SELECT * FROM :: fn_trace_getinfo(default)
1 1 6
1 2 F:\Program Files\Microsoft SQL Server\MSSQL\Data\audittrace_20050317085321
1 3 200
1 4 NULL
1 5 1

I am unable to stop and delete it executing the following...
exec sp_trace_setstatus 1,0
go
exec sp_trace_setstatus 1,2
go
Crashes the server!?

Is there another method to kill this trace?

Thanks, Jim"

the trace ID is 1? if the 2nd query doesn't work, will restarting the sql agent stop the trace?

--------------------
keeping it simple...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources