{"id":2151,"date":"2013-04-07T08:22:00","date_gmt":"2013-04-07T15:22:00","guid":{"rendered":"http:\/\/www.brainlitter.com\/?p=2151"},"modified":"2013-04-07T08:22:00","modified_gmt":"2013-04-07T15:22:00","slug":"the-transaction-log-for-database-xxxx-is-full","status":"publish","type":"post","link":"https:\/\/regroove.ca\/brainlitter\/2013\/04\/07\/the-transaction-log-for-database-xxxx-is-full\/","title":{"rendered":"The Transaction Log for Database XXXX is full"},"content":{"rendered":"<p>Ran into this on Friday at a customer.&nbsp; Unexpected as the database logging file size shouldn\u2019t have been changed in the first place but it could happen elsewhere. Hope this helps others. <\/p>\n<h2>What<\/h2>\n<ul>\n<li>Event ID: <b>5586<\/b><\/li>\n<li>Error Posted: <i><font face=\"Cordia New\">Unknown SQL Exception 9002 occurred. Additional error information from SQL Server is included below. The transaction log for database &#8216;ContentDB02&#8217; is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases<\/font><\/i><\/li>\n<\/ul>\n<h2>So What<\/h2>\n<p>Sucks don\u2019t it? SharePoint can\u2019t write anymore. From the SharePoint side, certain site collections couldn\u2019t add\/edit content but SharePoint pages would still render. When writing, a generic correlation ID would appear so the clue was in the Servers Event Logs only. <\/p>\n<p>The reality\/issue was that the database in question was changed from its default logging database maximum size of 2,097,152 MB to 2,048MB (2GB). Sure enough, on the file system, the LDB file for the database was showing 1.9GB or so. Not sure who changed this from the default but that is another story. As the logfiles are well managed and checked, it was recent activity (huge volumes) of transactions within a matter of a day or so that caused it to climb. <\/p>\n<h2>Now What<\/h2>\n<p>While there is a bunch of ways to approach this, short and sweet was in order as I had a class to teach. \ud83d\ude09 <\/p>\n<ol>\n<li>First off was to shrink the logging database file (in SQL manager, shrink the database and the file, first of course setting its database recovery type to Simple)<\/li>\n<li>Set the database limit back to the defaults \u2026 as it shouldn\u2019t have been changed in the first place in this circumstance<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Ran into this on Friday at a customer.&nbsp; Unexpected as the database logging file size shouldn\u2019t have been changed in the first place but it could happen elsewhere. Hope this helps others. What Event ID: 5586 Error Posted: Unknown SQL Exception 9002 occurred. Additional error information from SQL Server is included below. The transaction log &hellip; <a href=\"https:\/\/regroove.ca\/brainlitter\/2013\/04\/07\/the-transaction-log-for-database-xxxx-is-full\/\"><\/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,194,428],"tags":[579,30,552],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>The Transaction Log for Database XXXX is full - 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\/2013\/04\/07\/the-transaction-log-for-database-xxxx-is-full\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The Transaction Log for Database XXXX is full - Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"og:description\" content=\"Ran into this on Friday at a customer.&nbsp; Unexpected as the database logging file size shouldn\u2019t have been changed in the first place but it could happen elsewhere. Hope this helps others. What Event ID: 5586 Error Posted: Unknown SQL Exception 9002 occurred. Additional error information from SQL Server is included below. The transaction log &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/regroove.ca\/brainlitter\/2013\/04\/07\/the-transaction-log-for-database-xxxx-is-full\/\" \/>\n<meta property=\"og:site_name\" content=\"Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"article:published_time\" content=\"2013-04-07T15:22: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\":\"https:\/\/regroove.ca\/brainlitter\/2013\/04\/07\/the-transaction-log-for-database-xxxx-is-full\/\",\"url\":\"https:\/\/regroove.ca\/brainlitter\/2013\/04\/07\/the-transaction-log-for-database-xxxx-is-full\/\",\"name\":\"The Transaction Log for Database XXXX is full - Brainlitter - Inside the mind of Sean Wallbridge\",\"isPartOf\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#website\"},\"datePublished\":\"2013-04-07T15:22:00+00:00\",\"dateModified\":\"2013-04-07T15:22:00+00:00\",\"author\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77\"},\"breadcrumb\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/2013\/04\/07\/the-transaction-log-for-database-xxxx-is-full\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/regroove.ca\/brainlitter\/2013\/04\/07\/the-transaction-log-for-database-xxxx-is-full\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/2013\/04\/07\/the-transaction-log-for-database-xxxx-is-full\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Brainlitter\",\"item\":\"https:\/\/regroove.ca\/brainlitter\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The Transaction Log for Database XXXX is full\"}]},{\"@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":"The Transaction Log for Database XXXX is full - 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\/2013\/04\/07\/the-transaction-log-for-database-xxxx-is-full\/","og_locale":"en_US","og_type":"article","og_title":"The Transaction Log for Database XXXX is full - Brainlitter - Inside the mind of Sean Wallbridge","og_description":"Ran into this on Friday at a customer.&nbsp; Unexpected as the database logging file size shouldn\u2019t have been changed in the first place but it could happen elsewhere. Hope this helps others. What Event ID: 5586 Error Posted: Unknown SQL Exception 9002 occurred. Additional error information from SQL Server is included below. The transaction log &hellip;","og_url":"https:\/\/regroove.ca\/brainlitter\/2013\/04\/07\/the-transaction-log-for-database-xxxx-is-full\/","og_site_name":"Brainlitter - Inside the mind of Sean Wallbridge","article_published_time":"2013-04-07T15:22: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":"https:\/\/regroove.ca\/brainlitter\/2013\/04\/07\/the-transaction-log-for-database-xxxx-is-full\/","url":"https:\/\/regroove.ca\/brainlitter\/2013\/04\/07\/the-transaction-log-for-database-xxxx-is-full\/","name":"The Transaction Log for Database XXXX is full - Brainlitter - Inside the mind of Sean Wallbridge","isPartOf":{"@id":"https:\/\/regroove.ca\/brainlitter\/#website"},"datePublished":"2013-04-07T15:22:00+00:00","dateModified":"2013-04-07T15:22:00+00:00","author":{"@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77"},"breadcrumb":{"@id":"https:\/\/regroove.ca\/brainlitter\/2013\/04\/07\/the-transaction-log-for-database-xxxx-is-full\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/regroove.ca\/brainlitter\/2013\/04\/07\/the-transaction-log-for-database-xxxx-is-full\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/regroove.ca\/brainlitter\/2013\/04\/07\/the-transaction-log-for-database-xxxx-is-full\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Brainlitter","item":"https:\/\/regroove.ca\/brainlitter\/"},{"@type":"ListItem","position":2,"name":"The Transaction Log for Database XXXX is full"}]},{"@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\/2151"}],"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=2151"}],"version-history":[{"count":0,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts\/2151\/revisions"}],"wp:attachment":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/media?parent=2151"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/categories?post=2151"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/tags?post=2151"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}