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.
User contributions licensed under CC BY-SA 3.0