{"id":222,"date":"2007-05-08T22:00:00","date_gmt":"2007-05-08T22:00:00","guid":{"rendered":"https:\/\/brainlitter.itgroove.net\/2007\/05\/08\/sql-server-2000-disks-filling-up-with-database-backups-that-arent-being-removed-purged\/"},"modified":"2007-05-08T22:00:00","modified_gmt":"2007-05-08T22:00:00","slug":"sql-server-2000-disks-filling-up-with-database-backups-that-arent-being-removed-purged","status":"publish","type":"post","link":"https:\/\/regroove.ca\/brainlitter\/2007\/05\/08\/sql-server-2000-disks-filling-up-with-database-backups-that-arent-being-removed-purged\/","title":{"rendered":"SQL Server 2000 Disks filling up with Database Backups that aren’t being removed\/purged?"},"content":{"rendered":"
\n

I’ve been seeing this happen quite a bit…<\/p><\/blockquote>\n

WHAT?<\/strong>
SQL Server disks are filling up with backups from Database Maintenance Plans despite having settings that they should be removing transaction log or database backups after X days.<\/p>\n

SO WHAT?<\/strong>
The problem is that a Database Maintenance Plan cannot properly purge these backups if the job contains any databases that have mismatched backup job ‘recovery modes’. For example, most databases by default start off with the ‘Full’ Recovery Mode, yet some system databases only allow the ‘Simple’ Recovery Mode.<\/p>\n

As defined in http:\/\/support.microsoft.com\/kb\/303292\/en-us <\/a><\/strong>, this just won’t work (i.e. your backup files will grow and grow and grow and never get lopped off ‘after Y days’ as you might have defined in your maintenance plan.<\/p>\n

NOW WHAT?<\/strong>
Well, you can approach this several ways but possibly the best way is to follow these simple rules:<\/p>\n

– Create a separate database backup plan for your User Databases (production) and a separate database plan for your System Databases<\/p>\n

– Should you decide to change the recovery mode for a Production Database, be sure to have a separate Database Maintenance Plan (or perhaps have a ‘Full Database Recovery Maintenance Plan’ and a ‘Simple Database Recovery Maintenance Plan’<\/p>\n

– Consider having a separate plan altogether for the ‘other’ actions you might want, such as optimizations and integrity checks so that any failure of these do not disrupt the success of your backups<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

I’ve been seeing this happen quite a bit… WHAT?SQL Server disks are filling up with backups from Database Maintenance Plans despite having settings that they should be removing transaction log or database backups after X days. SO WHAT?The problem is that a Database Maintenance Plan cannot properly purge these backups if the job contains any … <\/a><\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":"","_jetpack_memberships_contains_paid_content":false},"categories":[189],"tags":[],"acf":[],"yoast_head":"\nSQL Server 2000 Disks filling up with Database Backups that aren't being removed\/purged? - Brainlitter - Inside the mind of Sean Wallbridge<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/regroove.ca\/brainlitter\/2007\/05\/08\/sql-server-2000-disks-filling-up-with-database-backups-that-arent-being-removed-purged\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2000 Disks filling up with Database Backups that aren't being removed\/purged? - Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"og:description\" content=\"I’ve been seeing this happen quite a bit… WHAT?SQL Server disks are filling up with backups from Database Maintenance Plans despite having settings that they should be removing transaction log or database backups after X days. SO WHAT?The problem is that a Database Maintenance Plan cannot properly purge these backups if the job contains any …\" \/>\n<meta property=\"og:url\" content=\"http:\/\/regroove.ca\/brainlitter\/2007\/05\/08\/sql-server-2000-disks-filling-up-with-database-backups-that-arent-being-removed-purged\/\" \/>\n<meta property=\"og:site_name\" content=\"Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"article:published_time\" content=\"2007-05-08T22:00:00+00:00\" \/>\n<meta name=\"author\" content=\"Sean Wallbridge\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sean Wallbridge\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"http:\/\/regroove.ca\/brainlitter\/2007\/05\/08\/sql-server-2000-disks-filling-up-with-database-backups-that-arent-being-removed-purged\/\",\"url\":\"http:\/\/regroove.ca\/brainlitter\/2007\/05\/08\/sql-server-2000-disks-filling-up-with-database-backups-that-arent-being-removed-purged\/\",\"name\":\"SQL Server 2000 Disks filling up with Database Backups that aren't being removed\/purged? - Brainlitter - Inside the mind of Sean Wallbridge\",\"isPartOf\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#website\"},\"datePublished\":\"2007-05-08T22:00:00+00:00\",\"dateModified\":\"2007-05-08T22:00:00+00:00\",\"author\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77\"},\"breadcrumb\":{\"@id\":\"http:\/\/regroove.ca\/brainlitter\/2007\/05\/08\/sql-server-2000-disks-filling-up-with-database-backups-that-arent-being-removed-purged\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/regroove.ca\/brainlitter\/2007\/05\/08\/sql-server-2000-disks-filling-up-with-database-backups-that-arent-being-removed-purged\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/regroove.ca\/brainlitter\/2007\/05\/08\/sql-server-2000-disks-filling-up-with-database-backups-that-arent-being-removed-purged\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Brainlitter\",\"item\":\"https:\/\/regroove.ca\/brainlitter\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2000 Disks filling up with Database Backups that aren’t being removed\/purged?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#website\",\"url\":\"https:\/\/regroove.ca\/brainlitter\/\",\"name\":\"Brainlitter - Inside the mind of Sean Wallbridge\",\"description\":\"Dad. Husband. Drummer. Learner of Things.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/regroove.ca\/brainlitter\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77\",\"name\":\"Sean Wallbridge\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g\",\"caption\":\"Sean Wallbridge\"},\"url\":\"https:\/\/regroove.ca\/brainlitter\/author\/swallbridge\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server 2000 Disks filling up with Database Backups that aren't being removed\/purged? - Brainlitter - Inside the mind of Sean Wallbridge","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":"http:\/\/regroove.ca\/brainlitter\/2007\/05\/08\/sql-server-2000-disks-filling-up-with-database-backups-that-arent-being-removed-purged\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2000 Disks filling up with Database Backups that aren't being removed\/purged? - Brainlitter - Inside the mind of Sean Wallbridge","og_description":"I’ve been seeing this happen quite a bit… WHAT?SQL Server disks are filling up with backups from Database Maintenance Plans despite having settings that they should be removing transaction log or database backups after X days. SO WHAT?The problem is that a Database Maintenance Plan cannot properly purge these backups if the job contains any …","og_url":"http:\/\/regroove.ca\/brainlitter\/2007\/05\/08\/sql-server-2000-disks-filling-up-with-database-backups-that-arent-being-removed-purged\/","og_site_name":"Brainlitter - Inside the mind of Sean Wallbridge","article_published_time":"2007-05-08T22:00:00+00:00","author":"Sean Wallbridge","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Sean Wallbridge","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"http:\/\/regroove.ca\/brainlitter\/2007\/05\/08\/sql-server-2000-disks-filling-up-with-database-backups-that-arent-being-removed-purged\/","url":"http:\/\/regroove.ca\/brainlitter\/2007\/05\/08\/sql-server-2000-disks-filling-up-with-database-backups-that-arent-being-removed-purged\/","name":"SQL Server 2000 Disks filling up with Database Backups that aren't being removed\/purged? - Brainlitter - Inside the mind of Sean Wallbridge","isPartOf":{"@id":"https:\/\/regroove.ca\/brainlitter\/#website"},"datePublished":"2007-05-08T22:00:00+00:00","dateModified":"2007-05-08T22:00:00+00:00","author":{"@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77"},"breadcrumb":{"@id":"http:\/\/regroove.ca\/brainlitter\/2007\/05\/08\/sql-server-2000-disks-filling-up-with-database-backups-that-arent-being-removed-purged\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/regroove.ca\/brainlitter\/2007\/05\/08\/sql-server-2000-disks-filling-up-with-database-backups-that-arent-being-removed-purged\/"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/regroove.ca\/brainlitter\/2007\/05\/08\/sql-server-2000-disks-filling-up-with-database-backups-that-arent-being-removed-purged\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Brainlitter","item":"https:\/\/regroove.ca\/brainlitter\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2000 Disks filling up with Database Backups that aren’t being removed\/purged?"}]},{"@type":"WebSite","@id":"https:\/\/regroove.ca\/brainlitter\/#website","url":"https:\/\/regroove.ca\/brainlitter\/","name":"Brainlitter - Inside the mind of Sean Wallbridge","description":"Dad. Husband. Drummer. Learner of Things.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/regroove.ca\/brainlitter\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77","name":"Sean Wallbridge","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g","caption":"Sean Wallbridge"},"url":"https:\/\/regroove.ca\/brainlitter\/author\/swallbridge\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts\/222"}],"collection":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/comments?post=222"}],"version-history":[{"count":0,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts\/222\/revisions"}],"wp:attachment":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/media?parent=222"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/categories?post=222"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/tags?post=222"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}