{"id":986,"date":"2012-02-28T22:03:38","date_gmt":"2012-02-29T06:03:38","guid":{"rendered":"http:\/\/blog.brainlitter.com\/2012\/02\/28\/uh-oh-my-sharepoint-sql-database-log-files-are-huge\/"},"modified":"2012-02-28T22:03:38","modified_gmt":"2012-02-29T06:03:38","slug":"uh-oh-my-sharepoint-sql-database-log-files-are-huge","status":"publish","type":"post","link":"https:\/\/regroove.ca\/brainlitter\/2012\/02\/28\/uh-oh-my-sharepoint-sql-database-log-files-are-huge\/","title":{"rendered":"Uh Oh, My SharePoint SQL Database Log Files are huge!"},"content":{"rendered":"

It happens often enough in the SMB space that this quick video how to was warranted.  SharePoint uses SQL Server. SQL Server has databases.  Those databases have log files.  Those log files can get quite big if not properly maintained or if backup software doesn’t do its job to inform SQL that the log files can be truncated (shrunk) after a successful backup has been performed, when a database is set to use the "Full" recovery type.<\/p>\n

\n
[youtube https:\/\/www.youtube.com\/watch?v=kZeI37Fr6_k&hl=en&hd=1]<\/div>\n
Learn to tame your logfiles\u2026<\/div>\n<\/div>\n

 <\/p>\n

This short video shows how to change the database recovery type, shrink the database and then put it back the way it was…<\/p>\n

Hope it helps someone out there.
Sean @itgroove<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

It happens often enough in the SMB space that this quick video how to was warranted.  SharePoint uses SQL Server. SQL Server has databases.  Those databases have log files.  Those log files can get quite big if not properly maintained or if backup software doesn’t do its job to inform SQL that the log files … <\/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":[14,399,334,453,450,428,339],"tags":[550,551,552],"acf":[],"yoast_head":"\nUh Oh, My SharePoint SQL Database Log Files are huge! - 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=\"https:\/\/regroove.ca\/brainlitter\/2012\/02\/28\/uh-oh-my-sharepoint-sql-database-log-files-are-huge\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Uh Oh, My SharePoint SQL Database Log Files are huge! - Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"og:description\" content=\"It happens often enough in the SMB space that this quick video how to was warranted.  SharePoint uses SQL Server. SQL Server has databases.  Those databases have log files.  Those log files can get quite big if not properly maintained or if backup software doesn’t do its job to inform SQL that the log files …\" \/>\n<meta property=\"og:url\" content=\"https:\/\/regroove.ca\/brainlitter\/2012\/02\/28\/uh-oh-my-sharepoint-sql-database-log-files-are-huge\/\" \/>\n<meta property=\"og:site_name\" content=\"Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"article:published_time\" content=\"2012-02-29T06:03:38+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\":\"https:\/\/regroove.ca\/brainlitter\/2012\/02\/28\/uh-oh-my-sharepoint-sql-database-log-files-are-huge\/\",\"url\":\"https:\/\/regroove.ca\/brainlitter\/2012\/02\/28\/uh-oh-my-sharepoint-sql-database-log-files-are-huge\/\",\"name\":\"Uh Oh, My SharePoint SQL Database Log Files are huge! - Brainlitter - Inside the mind of Sean Wallbridge\",\"isPartOf\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#website\"},\"datePublished\":\"2012-02-29T06:03:38+00:00\",\"dateModified\":\"2012-02-29T06:03:38+00:00\",\"author\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77\"},\"breadcrumb\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/2012\/02\/28\/uh-oh-my-sharepoint-sql-database-log-files-are-huge\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/regroove.ca\/brainlitter\/2012\/02\/28\/uh-oh-my-sharepoint-sql-database-log-files-are-huge\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/2012\/02\/28\/uh-oh-my-sharepoint-sql-database-log-files-are-huge\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Brainlitter\",\"item\":\"https:\/\/regroove.ca\/brainlitter\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Uh Oh, My SharePoint SQL Database Log Files are huge!\"}]},{\"@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":"Uh Oh, My SharePoint SQL Database Log Files are huge! - 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":"https:\/\/regroove.ca\/brainlitter\/2012\/02\/28\/uh-oh-my-sharepoint-sql-database-log-files-are-huge\/","og_locale":"en_US","og_type":"article","og_title":"Uh Oh, My SharePoint SQL Database Log Files are huge! - Brainlitter - Inside the mind of Sean Wallbridge","og_description":"It happens often enough in the SMB space that this quick video how to was warranted.  SharePoint uses SQL Server. SQL Server has databases.  Those databases have log files.  Those log files can get quite big if not properly maintained or if backup software doesn’t do its job to inform SQL that the log files …","og_url":"https:\/\/regroove.ca\/brainlitter\/2012\/02\/28\/uh-oh-my-sharepoint-sql-database-log-files-are-huge\/","og_site_name":"Brainlitter - Inside the mind of Sean Wallbridge","article_published_time":"2012-02-29T06:03:38+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":"https:\/\/regroove.ca\/brainlitter\/2012\/02\/28\/uh-oh-my-sharepoint-sql-database-log-files-are-huge\/","url":"https:\/\/regroove.ca\/brainlitter\/2012\/02\/28\/uh-oh-my-sharepoint-sql-database-log-files-are-huge\/","name":"Uh Oh, My SharePoint SQL Database Log Files are huge! - Brainlitter - Inside the mind of Sean Wallbridge","isPartOf":{"@id":"https:\/\/regroove.ca\/brainlitter\/#website"},"datePublished":"2012-02-29T06:03:38+00:00","dateModified":"2012-02-29T06:03:38+00:00","author":{"@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77"},"breadcrumb":{"@id":"https:\/\/regroove.ca\/brainlitter\/2012\/02\/28\/uh-oh-my-sharepoint-sql-database-log-files-are-huge\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/regroove.ca\/brainlitter\/2012\/02\/28\/uh-oh-my-sharepoint-sql-database-log-files-are-huge\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/regroove.ca\/brainlitter\/2012\/02\/28\/uh-oh-my-sharepoint-sql-database-log-files-are-huge\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Brainlitter","item":"https:\/\/regroove.ca\/brainlitter\/"},{"@type":"ListItem","position":2,"name":"Uh Oh, My SharePoint SQL Database Log Files are huge!"}]},{"@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\/986"}],"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=986"}],"version-history":[{"count":0,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts\/986\/revisions"}],"wp:attachment":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/media?parent=986"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/categories?post=986"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/tags?post=986"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}