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.
| Author |
Topic |
|
lorellana
Starting Member
25 Posts |
 Posted - 2011-11-29 : 22:44:51
|
| When I restart the server that hosts the database engine SQL Server 2005 Standard Edition SP4, the trace gets up mytrace-5.trc with a size of 100 MB and id is 2, leaving the hard disk space, then the SQL Server stops execution of the trace due to lack of space. I do not know how to erase the trace, because I do not know where is it.The archive log looks like:SQL Trace ID 2 was started by login "sa"Trace ID '2' was stopped because of an error. Cause: 0x80070070(There is not enough space on the disk.). Restart the trace after correcting the problem. I only know how delete a trace, knowing id.EXEC sp_trace_setstatus 2, 0EXEC sp_trace_setstatus 2, 2Can you tell me in which configuration file I can disable all SQL Server traces.If I run select * from sys.traces, I just get only the default trace:id = 1status = 1 path= D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\log_32736.trcmax_size = 20 stop_time = NULL max_files = 5 is_rowset = 0 is_rollover = 1 is_shutdown = 0 is_default = 1 buffer_count = 2 buffer_size = 128 file_position = 2359296 reader_spid = NULL start_time = 2011-11-26 07:01:41.403 last_event_time = 2011-11-29 22:12:28.160 event_count = 12851 dropped_event_count = NULL |
|
|
|
|
|
Which configuration file I can disable traces