{"id":6853,"date":"2016-01-14T15:16:27","date_gmt":"2016-01-14T14:16:27","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/"},"modified":"2016-01-14T15:16:27","modified_gmt":"2016-01-14T14:16:27","slug":"sql-server-tips-default-trace-enabled-but-no-file-is-active","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/","title":{"rendered":"SQL Server Tips: Default trace enabled but no file is active\u2026"},"content":{"rendered":"<p>I discover a strange error with a customer about the default trace.<br \/>\nAs you know, SQL Server has a default trace with a lot of events like the data and log file growth.<br \/>\nThis trace is enabled by default and you have five .trc files located in the installation directory of SQL Server.<\/p>\n<p>In my case, I search through the trace file, the growth history of data files with this query:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">DECLARE @filename NVARCHAR(1000);\nDECLARE @bc INT;\nDECLARE @ec INT;\nDECLARE @bfn VARCHAR(1000);\nDECLARE @efn VARCHAR(10);\n \n-- Get the name of the current default trace\nSELECT @filename = CAST(value AS NVARCHAR(1000))\nFROM ::fn_trace_getinfo(DEFAULT)\nWHERE traceid = 1 AND property = 2;\n\n-- rip apart file name into pieces\nSET @filename = REVERSE(@filename);\nSET @bc = CHARINDEX('.',@filename);\nSET @ec = CHARINDEX('_',@filename)+1;\nSET @efn = REVERSE(SUBSTRING(@filename,1,@bc));\nSET @bfn = REVERSE(SUBSTRING(@filename,@ec,LEN(@filename)));\n\n-- set filename without rollover number\nSET @filename = @bfn + @efn\nIF EXISTS (SELECT * FROM ::fn_trace_gettable(@filename, DEFAULT) AS ftg \n               WHERE (EventClass = 92  -- Date File Auto-grow\n                   OR EventClass = 93) -- Log File Auto-grow\n                  AND StartTime &gt; DATEADD(dy,-7,GETDATE())) \n\n  BEGIN -- If there are autogrows in the last day \n\tSELECT * INTO #temp_trc FROM ::fn_trace_gettable(@filename, DEFAULT) AS ftg \n\tWHERE (EventClass = 92  -- Date File Auto-grow\n        OR EventClass = 93) -- Log File Auto-grow\n       AND StartTime &gt; DATEADD(dy,-7,GETDATE())\n\n\tSelect  CONVERT(varchar,StartTime,102) as grow_date,DatabaseName as database_name,FileName as file_name,te.name as event_class,Duration\/1000  as Duration,(tmp.IntegerData*8)\/1024.0 as size_MB into #temp_trc2 from #temp_trc AS tmp \n               INNER JOIN sys.trace_events AS te ON tmp.EventClass = te.trace_event_id  \n\n\tSELECT grow_date,event_class,database_name,file_name,Count(Duration),Convert(int,Sum(size_MB)) , Sum(Duration) \n\tfrom #temp_trc2 GROUP BY grow_date,database_name,file_name,event_class\t\t\n    ORDER BY grow_date, database_name\n\t\n\tDROP TABLE #temp_trc2\n\tDROP TABLE #temp_trc\n  END\n\n<\/pre>\n<p>But I got no result\u2026<br \/>\nThe first step was to verify if the default trace is enabled with the command:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SELECT * FROM sys.configurations WHERE name=\u2019default trace enable\u2019<\/pre>\n<p>It is enabled, then I check the current running trace with the view sys.traces<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SELECT * FROM sys.traces<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/TraceEnableButNotActivate01.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-6575 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/TraceEnableButNotActivate01.png\" alt=\"TraceEnableButNotActivate01\" width=\"300\" height=\"78\" \/><\/a><\/p>\n<p>As you can see, I have no file returned by the view.<br \/>\nIf I check directly the installation directory, I see the five trace files.<br \/>\nThis situation is very strange\u2026.<br \/>\nThe real question is \u201cWhat can I do?\u201d<br \/>\nThe solution was very simple.<br \/>\nI disable and re-enable the default trace with the sp_configure:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">EXEC sp_configure \u2018show advanced options\u2019,1;\nGO\nRECONFIGURE WITH OVERRIDE;\nGO\nEXEC sp_configure \u2018default trace enabled,0;\nGO\nRECONFIGURE WITH OVERRIDE;\nGO\nEXEC sp_configure \u2018default trace enabled,1;\nGO\nRECONFIGURE WITH OVERRIDE;\nGO\nEXEC sp_configure \u2018show advanced options\u2019,0;\nGO\nRECONFIGURE WITH OVERRIDE;\nGO<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/TraceEnableButNotActivate02.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-6576 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/TraceEnableButNotActivate02.png\" alt=\"TraceEnableButNotActivate02\" width=\"300\" height=\"135\" \/><\/a><\/p>\n<p>After this, I re-run the query with the view sys.traces and I see that I have a current running trace file with a start_time from now.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/TraceEnableButNotActivate03.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-6577 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/TraceEnableButNotActivate03.png\" alt=\"TraceEnableButNotActivate03\" width=\"300\" height=\"75\" \/><\/a><\/p>\n<p>To be sure, I use the function fr_trace_getinfo to find the current running trace file<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/TraceEnableButNotActivate04.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-6578 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/TraceEnableButNotActivate04.png\" alt=\"TraceEnableButNotActivate04\" width=\"300\" height=\"138\" \/><\/a><\/p>\n<p>To prevent this problem, I add a condition:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">IF (select count(*) FROM sys.traces ) &gt;0<\/pre>\n<p>The entire query:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">DECLARE @filename NVARCHAR(1000);\nDECLARE @bc INT;\nDECLARE @ec INT;\nDECLARE @bfn VARCHAR(1000);\nDECLARE @efn VARCHAR(10);\n\nIF (select count(*) FROM sys.traces ) &gt;0\nBEGIN\n \n-- Get the name of the current default trace\nSELECT @filename = CAST(value AS NVARCHAR(1000))\nFROM ::fn_trace_getinfo(DEFAULT)\nWHERE traceid = 1 AND property = 2;\n\n-- rip apart file name into pieces\nSET @filename = REVERSE(@filename);\nSET @bc = CHARINDEX('.',@filename);\nSET @ec = CHARINDEX('_',@filename)+1;\nSET @efn = REVERSE(SUBSTRING(@filename,1,@bc));\nSET @bfn = REVERSE(SUBSTRING(@filename,@ec,LEN(@filename)));\n\n-- set filename without rollover number\nSET @filename = @bfn + @efn\nIF EXISTS (SELECT * FROM ::fn_trace_gettable(@filename, DEFAULT) AS ftg \n               WHERE (EventClass = 92  -- Date File Auto-grow\n                   OR EventClass = 93) -- Log File Auto-grow\n                  AND StartTime &gt; DATEADD(dy,-7,GETDATE())) \n\n  BEGIN -- If there are autogrows in the last day \n\tSELECT * INTO #temp_trc FROM ::fn_trace_gettable(@filename, DEFAULT) AS ftg \n\tWHERE (EventClass = 92  -- Date File Auto-grow\n        OR EventClass = 93) -- Log File Auto-grow\n       AND StartTime &gt; DATEADD(dy,-7,GETDATE())\n\n\tSelect  CONVERT(varchar,StartTime,102) as grow_date,DatabaseName as database_name,FileName as file_name,te.name as event_class,Duration\/1000  as Duration,(tmp.IntegerData*8)\/1024.0 as size_MB into #temp_trc2 from #temp_trc AS tmp \n               INNER JOIN sys.trace_events AS te ON tmp.EventClass = te.trace_event_id  \n\n\tSELECT grow_date,event_class,database_name,file_name,Count(Duration),Convert(int,Sum(size_MB)) , Sum(Duration) \n\tfrom #temp_trc2 GROUP BY grow_date,database_name,file_name,event_class\t\t\n    ORDER BY grow_date, database_name\n\t\n\tDROP TABLE #temp_trc2\n\tDROP TABLE #temp_trc\n  END\n  END\n<\/pre>\n<p>After that, I can read the trace file to find all grows (Event Class 92 and 93) without an error due to the missing current running trace file.<br \/>\nTo be sure, I add a policy to check every day if a current running trace file is in place.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I discover a strange error with a customer about the default trace. As you know, SQL Server has a default trace with a lot of events like the data and log file growth. This trace is enabled by default and you have five .trc files located in the installation directory of SQL Server. In my&hellip;&nbsp;<\/p>\n","protected":false},"author":15,"featured_media":6858,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[4133],"tags":[49,339,44],"class_list":["post-6853","post","type-post","status-publish","format-standard","has-post-thumbnail","category-database","tag-microsoft","tag-trace","tag-troubleshooting"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.8 (Yoast SEO v28.9) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server Tips: Default trace enabled but no file is active\u2026<\/title>\n<meta name=\"description\" content=\"SQL Server has a default trace with a lot of events like the data and log file growth. The current running trace is missing with a default trace enable.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server Tips: Default trace enabled but no file is active\u2026\" \/>\n<meta property=\"og:description\" content=\"SQL Server has a default trace with a lot of events like the data and log file growth. The current running trace is missing with a default trace enable.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi services Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:published_time\" content=\"2016-01-14T14:16:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/TraceEnableButNotActivate01-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1213\" \/>\n\t<meta property=\"og:image:height\" content=\"315\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Haby\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Haby\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-tips-default-trace-enabled-but-no-file-is-active\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-tips-default-trace-enabled-but-no-file-is-active\\\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/7980252d7d7a521e285e7c66114cf82a\"},\"headline\":\"SQL Server Tips: Default trace enabled but no file is active\u2026\",\"datePublished\":\"2016-01-14T14:16:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-tips-default-trace-enabled-but-no-file-is-active\\\/\"},\"wordCount\":273,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-tips-default-trace-enabled-but-no-file-is-active\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/TraceEnableButNotActivate01-1.png\",\"keywords\":[\"Microsoft\",\"Trace\",\"Troubleshooting\"],\"articleSection\":[\"Database\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-tips-default-trace-enabled-but-no-file-is-active\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-tips-default-trace-enabled-but-no-file-is-active\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-tips-default-trace-enabled-but-no-file-is-active\\\/\",\"name\":\"SQL Server Tips: Default trace enabled but no file is active\u2026\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-tips-default-trace-enabled-but-no-file-is-active\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-tips-default-trace-enabled-but-no-file-is-active\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/TraceEnableButNotActivate01-1.png\",\"datePublished\":\"2016-01-14T14:16:27+00:00\",\"description\":\"SQL Server has a default trace with a lot of events like the data and log file growth. The current running trace is missing with a default trace enable.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-tips-default-trace-enabled-but-no-file-is-active\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-tips-default-trace-enabled-but-no-file-is-active\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-tips-default-trace-enabled-but-no-file-is-active\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/TraceEnableButNotActivate01-1.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/TraceEnableButNotActivate01-1.png\",\"width\":1213,\"height\":315},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-tips-default-trace-enabled-but-no-file-is-active\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server Tips: Default trace enabled but no file is active\u2026\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\",\"name\":\"dbi services\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/7980252d7d7a521e285e7c66114cf82a\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/STH_web-min-scaled.jpg\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/STH_web-min-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/STH_web-min-scaled.jpg\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than 20 years of experience in Microsoft solutions, specializing in the installation, migration, best practices, and performance analysis of Microsoft SQL Server, as well as Microsoft Business Intelligence solutions (SharePoint, Office) and .NET development for the banking sector. A former Microsoft Most Valuable Professional (MVP) and early adopter of Microsoft Team System in France, he has authored several technical articles. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. His industry experience covers chemicals and pharma, banking, and financial services.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/stephane-haby\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server Tips: Default trace enabled but no file is active\u2026","description":"SQL Server has a default trace with a lot of events like the data and log file growth. The current running trace is missing with a default trace enable.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server Tips: Default trace enabled but no file is active\u2026","og_description":"SQL Server has a default trace with a lot of events like the data and log file growth. The current running trace is missing with a default trace enable.","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/","og_site_name":"dbi services Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2016-01-14T14:16:27+00:00","og_image":[{"width":1213,"height":315,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/TraceEnableButNotActivate01-1.png","type":"image\/png"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7980252d7d7a521e285e7c66114cf82a"},"headline":"SQL Server Tips: Default trace enabled but no file is active\u2026","datePublished":"2016-01-14T14:16:27+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/"},"wordCount":273,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/TraceEnableButNotActivate01-1.png","keywords":["Microsoft","Trace","Troubleshooting"],"articleSection":["Database"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/","name":"SQL Server Tips: Default trace enabled but no file is active\u2026","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/TraceEnableButNotActivate01-1.png","datePublished":"2016-01-14T14:16:27+00:00","description":"SQL Server has a default trace with a lot of events like the data and log file growth. The current running trace is missing with a default trace enable.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/TraceEnableButNotActivate01-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/TraceEnableButNotActivate01-1.png","width":1213,"height":315},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server Tips: Default trace enabled but no file is active\u2026"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dbi-services.com\/#organization","name":"dbi services","url":"https:\/\/www.dbi-services.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7980252d7d7a521e285e7c66114cf82a","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/STH_web-min-scaled.jpg","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/STH_web-min-scaled.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/STH_web-min-scaled.jpg","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than 20 years of experience in Microsoft solutions, specializing in the installation, migration, best practices, and performance analysis of Microsoft SQL Server, as well as Microsoft Business Intelligence solutions (SharePoint, Office) and .NET development for the banking sector. A former Microsoft Most Valuable Professional (MVP) and early adopter of Microsoft Team System in France, he has authored several technical articles. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. His industry experience covers chemicals and pharma, banking, and financial services.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/6853","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=6853"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/6853\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/6858"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=6853"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=6853"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=6853"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}