Is the BlackBox Trace Gone on SQL Server 2016?

0

We've just migrated to SQL Server 2016 (SP1-CU8) Enterprise Edition. In the past, we always used the blackbox trace (as well as the default one) on our server instances. Right after the migration, we got an alert saying that the blackbox trace was missing. When I tried use the code to set up the blackbox trace from https://docs.microsoft.com/en-us/previous-versions/tn-archive/cc293615(v=technet.10), it returned this:

/*------------------------
DECLARE @TraceId int
DECLARE @maxfilesize bigint 
SET @maxfilesize = 25 
EXEC sp_trace_create
@TraceId OUTPUT, 
@options = 8, 
@tracefile = NULL,
@maxfilesize = @maxfilesize 
EXEC sp_trace_setstatus @TraceId, 1
------------------------*/
Windows error occurred while running SP_TRACE_CREATE. Error = 0x80070003(The system cannot find the path specified.).
Msg 19051, Level 16, State 1, Procedure sp_trace_create, Line 1
Unknown error occurred in the trace.
Msg 19059, Level 16, State 1, Procedure sp_trace_setstatus, Line 1
Could not find the requested trace.

This worked just fine on our other 2012 instances. I've tried Googling for more information on this with no helpful results. Any help would be appreciated.

sql-server
asked on Stack Overflow Oct 23, 2018 by PMooney • edited Oct 23, 2018 by jarlh

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0