{"id":7005,"date":"2018-12-31T20:08:18","date_gmt":"2018-12-31T20:08:18","guid":{"rendered":"https:\/\/dbtut.com\/?p=7005"},"modified":"2018-12-31T20:08:18","modified_gmt":"2018-12-31T20:08:18","slug":"the-transaction-log-for-database-dbname-is-full-due-to-log_backup","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/12\/31\/the-transaction-log-for-database-dbname-is-full-due-to-log_backup\/","title":{"rendered":"The transaction log for database ‘dbname’ is full due to ‘LOG_BACKUP’"},"content":{"rendered":"

 <\/p>\n

ERROR:<\/h3>\n

Message
\nExecuted as user: DOMAIN\\svc_SQLService. The transaction log for database ‘dbname’ is full due to ‘LOG_BACKUP’. [SQLSTATE 42000] (Error 9002) \u00a0BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). \u00a0The step failed.<\/p>\n

EXPLANATION:<\/h3>\n

You may get an error when you want to get a backup. In fact, the error message tells you what the error is. The main problem is that your Transaction Log file is full.<\/p>\n

Possible scenario is that the Recovery Model of your database is FULL. There is a Transaction that has a very long or expired transaction or the space inside the Transaction Log file is full and the automatic growth of the Transaction Log file is closed or the disk is full.<\/p>\n

SOLUTION:<\/h3>\n

In such a case, if you do not get a Transaction Log backup on a regular basis and you do not have Log Shipping, then you may consider converting the Recovery Model of the database to SIMPLE. Or you can take transaction log backups more frequently and keep the transaction log file size smaller.<\/p>\n

If the disk with your Transaction Log file is full, then simply turning the Recovery Model to SIMPLE may not save you; in this case you may want to consider creating another Transaction Log file on another available disk.<\/p>\n

You may want to read the following articles about the transaction log file and database recovery models.<\/p>\n

“What is SQL Server Transaction Log”,<\/a><\/p>\n

“What is Database Recovery Model”<\/a><\/p>\n\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"excerpt":{"rendered":"

  ERROR: Message Executed as user: DOMAIN\\svc_SQLService. The transaction log for database ‘dbname’ is full due to ‘LOG_BACKUP’. [SQLSTATE 42000] (Error 9002) \u00a0BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). \u00a0The step failed. EXPLANATION: You may get an error when you want to get a backup. In fact, the error message tells you what …<\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"author":423,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7005","post","type-post","status-publish","format-standard","","category-mssql"],"aioseo_notices":[],"yoast_head":"\nThe transaction log for database 'dbname' is full due to 'LOG_BACKUP' - Database Tutorials<\/title>\n<meta name=\"description\" content=\"The transaction log for database 'dbname' is full due to 'LOG_BACKUP'\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/12\/31\/the-transaction-log-for-database-dbname-is-full-due-to-log_backup\/\" \/>\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 'dbname' is full due to 'LOG_BACKUP' - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"The transaction log for database 'dbname' is full due to 'LOG_BACKUP'\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/12\/31\/the-transaction-log-for-database-dbname-is-full-due-to-log_backup\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-12-31T20:08:18+00:00\" \/>\n<meta name=\"author\" content=\"Ekrem \u00d6nsoy\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ekrem \u00d6nsoy\" \/>\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\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/31\/the-transaction-log-for-database-dbname-is-full-due-to-log_backup\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/31\/the-transaction-log-for-database-dbname-is-full-due-to-log_backup\/\"},\"author\":{\"name\":\"Ekrem \u00d6nsoy\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/42a3e874ed0bf8053fa123a3a1f6ee46\"},\"headline\":\"The transaction log for database ‘dbname’ is full due to ‘LOG_BACKUP’\",\"datePublished\":\"2018-12-31T20:08:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/31\/the-transaction-log-for-database-dbname-is-full-due-to-log_backup\/\"},\"wordCount\":255,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/12\/31\/the-transaction-log-for-database-dbname-is-full-due-to-log_backup\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/31\/the-transaction-log-for-database-dbname-is-full-due-to-log_backup\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/31\/the-transaction-log-for-database-dbname-is-full-due-to-log_backup\/\",\"name\":\"The transaction log for database 'dbname' is full due to 'LOG_BACKUP' - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"datePublished\":\"2018-12-31T20:08:18+00:00\",\"description\":\"The transaction log for database 'dbname' is full due to 'LOG_BACKUP'\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/31\/the-transaction-log-for-database-dbname-is-full-due-to-log_backup\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/12\/31\/the-transaction-log-for-database-dbname-is-full-due-to-log_backup\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/31\/the-transaction-log-for-database-dbname-is-full-due-to-log_backup\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The transaction log for database ‘dbname’ is full due to ‘LOG_BACKUP’\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/42a3e874ed0bf8053fa123a3a1f6ee46\",\"name\":\"Ekrem \u00d6nsoy\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/478b3dc5048390d7312367b30eee5be99c346dbd83706e82e0dd4e9678b77c94?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/478b3dc5048390d7312367b30eee5be99c346dbd83706e82e0dd4e9678b77c94?s=96&d=mm&r=g\",\"caption\":\"Ekrem \u00d6nsoy\"},\"description\":\"The original article was written in Turkish by Ekrem \u00d6nsoy and translated to English by dbtut with the consent of the author. The copyright of the article belongs to the author. The author shall not be liable in any way for any defect caused by translation.\",\"url\":\"https:\/\/dbtut.com\/index.php\/author\/ekremonsoy\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"The transaction log for database 'dbname' is full due to 'LOG_BACKUP' - Database Tutorials","description":"The transaction log for database 'dbname' is full due to 'LOG_BACKUP'","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:\/\/dbtut.com\/index.php\/2018\/12\/31\/the-transaction-log-for-database-dbname-is-full-due-to-log_backup\/","og_locale":"en_US","og_type":"article","og_title":"The transaction log for database 'dbname' is full due to 'LOG_BACKUP' - Database Tutorials","og_description":"The transaction log for database 'dbname' is full due to 'LOG_BACKUP'","og_url":"https:\/\/dbtut.com\/index.php\/2018\/12\/31\/the-transaction-log-for-database-dbname-is-full-due-to-log_backup\/","og_site_name":"Database Tutorials","article_published_time":"2018-12-31T20:08:18+00:00","author":"Ekrem \u00d6nsoy","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Ekrem \u00d6nsoy","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/31\/the-transaction-log-for-database-dbname-is-full-due-to-log_backup\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/31\/the-transaction-log-for-database-dbname-is-full-due-to-log_backup\/"},"author":{"name":"Ekrem \u00d6nsoy","@id":"https:\/\/dbtut.com\/#\/schema\/person\/42a3e874ed0bf8053fa123a3a1f6ee46"},"headline":"The transaction log for database ‘dbname’ is full due to ‘LOG_BACKUP’","datePublished":"2018-12-31T20:08:18+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/31\/the-transaction-log-for-database-dbname-is-full-due-to-log_backup\/"},"wordCount":255,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/12\/31\/the-transaction-log-for-database-dbname-is-full-due-to-log_backup\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/31\/the-transaction-log-for-database-dbname-is-full-due-to-log_backup\/","url":"https:\/\/dbtut.com\/index.php\/2018\/12\/31\/the-transaction-log-for-database-dbname-is-full-due-to-log_backup\/","name":"The transaction log for database 'dbname' is full due to 'LOG_BACKUP' - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"datePublished":"2018-12-31T20:08:18+00:00","description":"The transaction log for database 'dbname' is full due to 'LOG_BACKUP'","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/31\/the-transaction-log-for-database-dbname-is-full-due-to-log_backup\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/12\/31\/the-transaction-log-for-database-dbname-is-full-due-to-log_backup\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/31\/the-transaction-log-for-database-dbname-is-full-due-to-log_backup\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"The transaction log for database ‘dbname’ is full due to ‘LOG_BACKUP’"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/42a3e874ed0bf8053fa123a3a1f6ee46","name":"Ekrem \u00d6nsoy","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/478b3dc5048390d7312367b30eee5be99c346dbd83706e82e0dd4e9678b77c94?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/478b3dc5048390d7312367b30eee5be99c346dbd83706e82e0dd4e9678b77c94?s=96&d=mm&r=g","caption":"Ekrem \u00d6nsoy"},"description":"The original article was written in Turkish by Ekrem \u00d6nsoy and translated to English by dbtut with the consent of the author. The copyright of the article belongs to the author. The author shall not be liable in any way for any defect caused by translation.","url":"https:\/\/dbtut.com\/index.php\/author\/ekremonsoy\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/7005","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/423"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=7005"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/7005\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=7005"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=7005"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=7005"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}