{"id":472,"date":"2021-12-28T10:15:15","date_gmt":"2021-12-28T09:15:15","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/2021\/12\/28\/sql-server-msdb-too-big-with-the-table-dbo-sysmaintplan_logdetail\/"},"modified":"2022-04-06T08:26:19","modified_gmt":"2022-04-06T06:26:19","slug":"sql-server-msdb-too-big-with-the-table-dbo-sysmaintplan_logdetail","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-msdb-too-big-with-the-table-dbo-sysmaintplan_logdetail\/","title":{"rendered":"SQL Server: msdb too big with the table dbo.sysmaintplan_logdetail"},"content":{"rendered":"<p>Today, I was by a new customer and the I see that the msdb data file was over 4GB. A little too big&#8230;<\/p>\n<p>To see which table are so big, in SSMS, I select the msdb database, right-click, go in Reports&gt;Standards Reports&gt; Disk usage by Top Tables<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/purge_msdb.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-53363 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/purge_msdb.png\" alt=\"\" width=\"300\" height=\"75\" \/><\/a><br \/>\nAs you can see, the table <strong>dbo.sysmainplan_logdetail<\/strong> is the big one with a size of 2,3GB and 13205 records.<\/p>\n<p>This table is the log for the maintenance plan that is generated through the maintenance plan wizard in the management menu in SSMS. More information <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/maintenance-plans\/use-the-maintenance-plan-wizard?view=sql-server-ver15\" target=\"_blank\" rel=\"noopener\">here<\/a>.<\/p>\n<p>After googling about how to purge this table, I find a lot of articles describing a method to truncate the table.<\/p>\n<p>I was not really sure that is the good way to do it&#8230;<\/p>\n<p>For my experience, to purge log or history in the msdb, we have always a store procedure like sp_delete_backuphistory or sp_purge_jobhistory.<\/p>\n<p>I search in all Stored Procedure in the database msdb and finally find \u201c<strong>sp_maintplan_delete_log<\/strong>\u201d.<\/p>\n<p>I search also in the Microsoft documentation and and find only this sentence <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/maintenance-plans\/use-the-maintenance-plan-wizard?view=sql-server-ver15\" target=\"_blank\" rel=\"noopener\">here<\/a><\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/purge_msdb04.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-53360 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/purge_msdb04.png\" alt=\"\" width=\"300\" height=\"140\" \/><\/a><\/p>\n<p>To clean up the table dbo.sysmainplan_logdetail, I use this store procedure in a loop with timestamp to not fill the T-log file and keep only the 30 last days:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">DECLARE @date datetime, @sql nvarchar(1000)\n\nSET @date = CONVERT(nvarchar(10), getdate()-720 , 21)\n\nWHILE @date &lt;= CONVERT(nvarchar(10), getdate()-30 , 21)\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 BEGIN\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0SET @sql = N'EXEC [msdb].[dbo].[sp_maintplan_delete_log]\u00a0 @oldest_time = {ts''' + CONVERT(nvarchar(23), @date , 21) + N'''}'\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 EXEC(@sql)\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SET @date = @date +30\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PRINT @sql\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 END<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/purge_msdb02.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-53362 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/purge_msdb02.png\" alt=\"\" width=\"300\" height=\"230\" \/><\/a>5709 entries are before january 2020&#8230; \ud83d\ude33<\/p>\n<p>After this cleanup, the table <strong>dbo.sysmainplan_logdetail<\/strong>\u00a0 is reduced the number of entries from 13205 to <strong>152<\/strong> and the size from 2.3GB to <strong>35MB<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/purge_msdb03.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-53361 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/purge_msdb03.png\" alt=\"\" width=\"300\" height=\"212\" \/><\/a><\/p>\n<p>Et voila. To be complete, the best is also to do the same, as written in the Microsoft documentation, with the stored procedures sp_purge_jobhistory and sp_delete_backuphistory.<\/p>\n<p>I advise also to create a daily job to cleanup all histories used in your maintenance plans. \ud83d\ude0e<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Today, I was by a new customer and the I see that the msdb data file was over 4GB. A little too big&#8230; To see which table are so big, in SSMS, I select the msdb database, right-click, go in Reports&gt;Standards Reports&gt; Disk usage by Top Tables As you can see, the table dbo.sysmainplan_logdetail is [&hellip;]<\/p>\n","protected":false},"author":15,"featured_media":474,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,198,99],"tags":[49,51],"type_dbi":[],"class_list":["post-472","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","category-database-management","category-sql-server","tag-microsoft","tag-sql-server"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server: msdb too big with the table dbo.sysmaintplan_logdetail - dbi Blog<\/title>\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-msdb-too-big-with-the-table-dbo-sysmaintplan_logdetail\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server: msdb too big with the table dbo.sysmaintplan_logdetail\" \/>\n<meta property=\"og:description\" content=\"Today, I was by a new customer and the I see that the msdb data file was over 4GB. A little too big&#8230; To see which table are so big, in SSMS, I select the msdb database, right-click, go in Reports&gt;Standards Reports&gt; Disk usage by Top Tables As you can see, the table dbo.sysmainplan_logdetail is [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-msdb-too-big-with-the-table-dbo-sysmaintplan_logdetail\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-12-28T09:15:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-04-06T06:26:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/purge_msdb04.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2786\" \/>\n\t<meta property=\"og:image:height\" content=\"1297\" \/>\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: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=\"2 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-msdb-too-big-with-the-table-dbo-sysmaintplan_logdetail\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-msdb-too-big-with-the-table-dbo-sysmaintplan_logdetail\\\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"SQL Server: msdb too big with the table dbo.sysmaintplan_logdetail\",\"datePublished\":\"2021-12-28T09:15:15+00:00\",\"dateModified\":\"2022-04-06T06:26:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-msdb-too-big-with-the-table-dbo-sysmaintplan_logdetail\\\/\"},\"wordCount\":304,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-msdb-too-big-with-the-table-dbo-sysmaintplan_logdetail\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/01\\\/purge_msdb04.png\",\"keywords\":[\"Microsoft\",\"SQL Server\"],\"articleSection\":[\"Database Administration &amp; Monitoring\",\"Database management\",\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-msdb-too-big-with-the-table-dbo-sysmaintplan_logdetail\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-msdb-too-big-with-the-table-dbo-sysmaintplan_logdetail\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-msdb-too-big-with-the-table-dbo-sysmaintplan_logdetail\\\/\",\"name\":\"SQL Server: msdb too big with the table dbo.sysmaintplan_logdetail - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-msdb-too-big-with-the-table-dbo-sysmaintplan_logdetail\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-msdb-too-big-with-the-table-dbo-sysmaintplan_logdetail\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/01\\\/purge_msdb04.png\",\"datePublished\":\"2021-12-28T09:15:15+00:00\",\"dateModified\":\"2022-04-06T06:26:19+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-msdb-too-big-with-the-table-dbo-sysmaintplan_logdetail\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-msdb-too-big-with-the-table-dbo-sysmaintplan_logdetail\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-msdb-too-big-with-the-table-dbo-sysmaintplan_logdetail\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/01\\\/purge_msdb04.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/01\\\/purge_msdb04.png\",\"width\":2786,\"height\":1297},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-server-msdb-too-big-with-the-table-dbo-sysmaintplan_logdetail\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server: msdb too big with the table dbo.sysmaintplan_logdetail\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"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\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/d0bfb7484ae81c8980fc2b11334f803b\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \\\/ Financial Services, and many other industries.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/stephane-haby\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server: msdb too big with the table dbo.sysmaintplan_logdetail - dbi Blog","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-msdb-too-big-with-the-table-dbo-sysmaintplan_logdetail\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server: msdb too big with the table dbo.sysmaintplan_logdetail","og_description":"Today, I was by a new customer and the I see that the msdb data file was over 4GB. A little too big&#8230; To see which table are so big, in SSMS, I select the msdb database, right-click, go in Reports&gt;Standards Reports&gt; Disk usage by Top Tables As you can see, the table dbo.sysmainplan_logdetail is [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-msdb-too-big-with-the-table-dbo-sysmaintplan_logdetail\/","og_site_name":"dbi Blog","article_published_time":"2021-12-28T09:15:15+00:00","article_modified_time":"2022-04-06T06:26:19+00:00","og_image":[{"width":2786,"height":1297,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/purge_msdb04.png","type":"image\/png"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-msdb-too-big-with-the-table-dbo-sysmaintplan_logdetail\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-msdb-too-big-with-the-table-dbo-sysmaintplan_logdetail\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"SQL Server: msdb too big with the table dbo.sysmaintplan_logdetail","datePublished":"2021-12-28T09:15:15+00:00","dateModified":"2022-04-06T06:26:19+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-msdb-too-big-with-the-table-dbo-sysmaintplan_logdetail\/"},"wordCount":304,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-msdb-too-big-with-the-table-dbo-sysmaintplan_logdetail\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/purge_msdb04.png","keywords":["Microsoft","SQL Server"],"articleSection":["Database Administration &amp; Monitoring","Database management","SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-msdb-too-big-with-the-table-dbo-sysmaintplan_logdetail\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-msdb-too-big-with-the-table-dbo-sysmaintplan_logdetail\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-msdb-too-big-with-the-table-dbo-sysmaintplan_logdetail\/","name":"SQL Server: msdb too big with the table dbo.sysmaintplan_logdetail - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-msdb-too-big-with-the-table-dbo-sysmaintplan_logdetail\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-msdb-too-big-with-the-table-dbo-sysmaintplan_logdetail\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/purge_msdb04.png","datePublished":"2021-12-28T09:15:15+00:00","dateModified":"2022-04-06T06:26:19+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-msdb-too-big-with-the-table-dbo-sysmaintplan_logdetail\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-msdb-too-big-with-the-table-dbo-sysmaintplan_logdetail\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-msdb-too-big-with-the-table-dbo-sysmaintplan_logdetail\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/purge_msdb04.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/purge_msdb04.png","width":2786,"height":1297},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-msdb-too-big-with-the-table-dbo-sysmaintplan_logdetail\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server: msdb too big with the table dbo.sysmaintplan_logdetail"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","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":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \/ Financial Services, and many other industries.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/472","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=472"}],"version-history":[{"count":8,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/472\/revisions"}],"predecessor-version":[{"id":17017,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/472\/revisions\/17017"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/474"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=472"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=472"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=472"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=472"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}