Trace file error

• Krishna1

  Hall of Fame

  Points: 3666

  More actions

  April 9, 2013 at 10:36 pm

  #292129

  Dear all

  I am getting following error

  "Encountered an error or an unexpected end of trace file 'c:\Program Files\Microsoft SQL Server\MSSQL10_50.LOCAL2008EXPRESS\MSSQL\Log\log_31.trc'."

  How do i correct it?

  I get it when i run following script -

  DECLARE @filename NVARCHAR(1000);

  DECLARE @bc INT;

  DECLARE @ec INT;

  DECLARE @bfn VARCHAR(1000);

  DECLARE @efn VARCHAR(10);

  -- Get the name of the current default trace

  SELECT @filename = CAST(value AS NVARCHAR(1000))

  FROM ::fn_trace_getinfo(DEFAULT)

  WHERE traceid = 1 AND property = 2;

  -- rip apart file name into pieces

  SET @filename = REVERSE(@filename);

  SET @bc = CHARINDEX('.',@filename);

  SET @ec = CHARINDEX('_',@filename)+1;

  SET @efn = REVERSE(SUBSTRING(@filename,1,@bc));

  SET @bfn = REVERSE(SUBSTRING(@filename,@ec,LEN(@filename)));

  -- set filename without rollover number

  SET @filename = @bfn + @efn

  -- process all trace files

  SELECT

  ftg.StartTime

  ,te.name AS EventName

  ,DB_NAME(ftg.databaseid) AS DatabaseName

  ,ftg.Filename

  ,(ftg.IntegerData*8)/1024.0 AS GrowthMB

  ,(ftg.duration/1000)AS DurMS

  FROM ::fn_trace_gettable(@filename, DEFAULT) AS ftg

  INNER JOIN sys.trace_events AS te ON ftg.EventClass = te.trace_event_id

  WHERE (ftg.EventClass = 92 -- Date File Auto-grow

  OR ftg.EventClass = 93) -- Log File Auto-grow

  ORDER BY ftg.StartTime

  There are 4 trace files _31/_32/_33/_34

• x

  SSC-Insane

  Points: 23660

  More actions

  April 10, 2013 at 6:11 am

  #1605180

  Make sure one of the traces isn't still in progress! LOL dumb suggestion, shows how little I know etc etc but I haven't met my post quota for this week yet!

• D-SQL

  SSCrazy

  Points: 2265

  More actions

  December 18, 2013 at 8:52 am

  #1674475

  Hi I am having the same error. Did you ever figure out what this was?

  Thanks in Advance

• Perry Whittle

  SSC Guru

  Points: 234040

  More actions

  January 2, 2014 at 6:44 am

  #1676880

  Krishna1 (4/9/2013)

  ---

  DECLARE @filename NVARCHAR(1000);

  DECLARE @bc INT;

  DECLARE @ec INT;

  DECLARE @bfn VARCHAR(1000);

  DECLARE @efn VARCHAR(10);

  -- Get the name of the current default trace

  SELECT @filename = CAST(value AS NVARCHAR(1000))

  FROM ::fn_trace_getinfo(DEFAULT)

  WHERE traceid = 1 AND property = 2;

  -- rip apart file name into pieces

  SET @filename = REVERSE(@filename);

  SET @bc = CHARINDEX('.',@filename);

  SET @ec = CHARINDEX('_',@filename)+1;

  SET @efn = REVERSE(SUBSTRING(@filename,1,@bc));

  SET @bfn = REVERSE(SUBSTRING(@filename,@ec,LEN(@filename)));

  [/code]

  If all you want is the path, this is easier

  select reverse(substring(@filename, CHARINDEX('\', @filename, 0) + 1, LEN(@filename)))

  c:\Program Files\Microsoft SQL Server\MSSQL10_50.LOCAL2008EXPRESS\MSSQL\Log

  Or

  select reverse(substring(@filename, CHARINDEX('\', @filename, 0), LEN(@filename)))

  c:\Program Files\Microsoft SQL Server\MSSQL10_50.LOCAL2008EXPRESS\MSSQL\Log\

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs"