It seems on the rebbot of a server a trace had started and the audittrace*.trc files generated brought the drive space down to 0KB and stopped the Server. I have tried taking the trace off with this code
SELECT * FROM ::fn_trace_getinfo(default) WHERE property = 2;
DECLARE @TraceID int
SET @TraceID = 1
EXEC sp_trace_setstatus @TraceID, 0
EXEC sp_trace_setstatus @TraceID, 2
And the message I get is that I need to use SP_CONFIGURE. SO I tried disabling the C2 audit mode with this code
EXEC sp_configure 'c2 audit mode', '0';
RECONFIGURE;
EXEC sp_configure;
And the run value for the C2 audit mode is still 1. I am hesitant to stop the SQL SERver service and start it with a start parameter of -f to get the C2 audit mode to stop. Any help would be appreciated. Thanks
SELECT * FROM ::fn_trace_getinfo(default) WHERE property = 2;
DECLARE @TraceID int
SET @TraceID = 1
EXEC sp_trace_setstatus @TraceID, 0
EXEC sp_trace_setstatus @TraceID, 2
And the message I get is that I need to use SP_CONFIGURE. SO I tried disabling the C2 audit mode with this code
EXEC sp_configure 'c2 audit mode', '0';
RECONFIGURE;
EXEC sp_configure;
And the run value for the C2 audit mode is still 1. I am hesitant to stop the SQL SERver service and start it with a start parameter of -f to get the C2 audit mode to stop. Any help would be appreciated. Thanks