{"id":11039,"date":"2019-03-26T07:13:22","date_gmt":"2019-03-26T07:13:22","guid":{"rendered":"https:\/\/dbtut.com\/?p=11039"},"modified":"2020-10-13T20:32:38","modified_gmt":"2020-10-13T20:32:38","slug":"transaction-log-for-database-is-full-due-to-a-reason-active-transaction-log-backup-replication","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/03\/26\/transaction-log-for-database-is-full-due-to-a-reason-active-transaction-log-backup-replication\/","title":{"rendered":"Transaction Log For Database is Full Due To a Reason (ACTIVE_TRANSACTION, LOG_BACKUP, REPLICATION)"},"content":{"rendered":"<p>In this article, I will describe a few of the most known types and solutions of this error.<\/p>\n<h2>Possible Errors<\/h2>\n<ul type=\"disc\">\n<li>Transaction Log is Full Due To LOG_BACKUP<\/li>\n<li>Transaction Log is Full Due To ACTIVE TRANSACTION<\/li>\n<li>Transaction Log is Full Due To REPLICATION<\/li>\n<\/ul>\n<p>You can see why the Transaction Log file is FULL with the following script. I will explain the reasons and solutions of the three error I mentioned above.<\/p>\n<pre class=\"lang:default decode:true\">select log_reuse_wait_desc from sys.databases where name='your_db_name'<\/pre>\n<h2>Transaction Log is Full Due To LOG_BACKUP<\/h2>\n<p>If the transaction log is Full due to log_backup, it indicates that you used full recovery model, and do not backup transaction log regularly. To resolve this issue, you must backup your transaction log and then shrink. You can read the following articles for detailed information. Do not forget that you must backup transaction log file regularly when you use Full Recovery Model.<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/05\/26\/database-recovery-models-in-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">Database Recovery Models in SQL Server<\/a>&#8220;,<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/06\/03\/how-to-shrink-sql-server-transaction-log\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Shrink the Transaction Log<\/a>&#8221;<\/p>\n\n<h2>Transaction Log is Full Due To ACTIVE_TRANSACTION<\/h2>\n<p>I have experienced this problem in the Availability Group&#8217;s primary database. This is one of the rare problems I have experienced in the Availability Group until today.<\/p>\n<p>When this error occurs, the Transaction Log file was FULL even though a Transaction log is backed up.<\/p>\n<p>ACTIVE_TRANSACTION means that there is an active transaction in the database. Because of this, SQL Server can not truncate the transaction log file. To find out if this is really the case, you should run the following query and find out whether there is a long running query. If you have a long-running query, you can kill the query by talking to the application developer. I suggest that you do not kill the query without the application developer&#8217;s knowledge.<\/p>\n<pre class=\"lang:default decode:true\">SELECT sp.spid,st.text,sp.status,sp.login_time,sp.last_batch,\r\nsp.hostname,sp.loginame FROM sys.sysprocesses sp \r\nCROSS APPLY sys.dm_exec_sql_text(sp.sql_handle) st\r\nWHERE open_tran = 1 and sp.dbid=DB_ID('your_db_name')\r\norder by login_time asc<\/pre>\n<p>If the reason of the problem is ACTIVE_TRANSACTION and if there is no active transaction in the database and your database is include in an availability group, then follow the steps below to solve your problem.<\/p>\n<p>When I first encountered this problem, I solved the problem by removing the database from AG and taking it back to AG. But the problem has repeated itself several times. Because the database size is also large, I did not want to remove it from the AG each time.<\/p>\n<p>Then, I tried a method like below and it worked.<\/p>\n<p>First, we click the Suspend Data Movement in the primary database by right-clicking on the relevant database as follows.<\/p>\n<p id=\"ZOMrLuT\"><img loading=\"lazy\" decoding=\"async\" width=\"495\" height=\"311\" class=\"size-full wp-image-11041 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c99c54240529.png\" alt=\"\" \/><\/p>\n<p>Then back up the transaction log and click the Resume Data Movement by right-clicking on the relevant database in the primary node as follows.<\/p>\n<p>After doing this, the ACTIVE_TRANSACTION problem still persists for a while. When you go to the Secondary database and look at the sync status, you see &#8220;Not Synchronizing \/ In Recovery&#8221; as follows.<\/p>\n<p id=\"ZbzCsvZ\"><img loading=\"lazy\" decoding=\"async\" width=\"419\" height=\"43\" class=\"size-full wp-image-11043 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c99c69bd0efe.png\" alt=\"\" \/><\/p>\n<p>When you open the log file of the Secondary database, you will see that the database is trying to recover itself as follows.<\/p>\n<p id=\"nyScgeQ\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-11045 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c99c6bf177ec.png\" alt=\"\" width=\"713\" height=\"185\" \/><\/p>\n<p>When the recovery process you see in the screenshot above is complete, run the following script in the primary database.<\/p>\n<pre class=\"lang:default decode:true\">select log_reuse_wait_desc from sys.databases where name='your_db_name'<\/pre>\n<p>If the result is still ACTIVE_TRANSACTION, this means that your secondary database is still behind.<\/p>\n<p>Right click on the AG and click on the SHOW Dashboard, then click Add \/ Remove Columns from the area marked in the screenshot below to select Last Hardened Time and Last Commit Time.<\/p>\n<p>Last Hardened Time shows when the last log record was sent from primary database to secondary database. When I looked at it, it was up-to-date.<\/p>\n<p>Last Commit Time was almost 2.5 days behind. Since the Dashboard screen is automatically updated, you&#8217;ll see Last Commit Time progressing continuously. After a while, the Last Commit Time will catch up to date and the secondary database will switch to the Synchronized state and your problem will fixed.<\/p>\n<p id=\"QJGzEtO\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-11047 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c99c6e7bd7d4.png\" alt=\"\" width=\"685\" height=\"161\" \/><\/p>\n<p>When you run the query again, the result will now appear as NOTHING and the transaction log file will be shrinkable. You can complete the process by shrinking the transaction file. To shrink the transaction log file, you can use the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/06\/03\/how-to-shrink-sql-server-transaction-log\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Shrink SQL Server Transaction Log<\/a>&#8220;.<\/p>\n\n<h2>Transaction Log is Full Due To REPLICATION<\/h2>\n<p>I wrote an article about this topic named &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/05\/25\/sql-server-does-not-truncate-the-transaction-log-after-log-backup-and-can-not-shrink-the-transaction-log\/\" target=\"_blank\" rel=\"noopener noreferrer\">SQL Server Does Not Truncate the Transaction Log After Log Backup and Can Not Shrink the Transaction Log<\/a>&#8220;. You can find detailed explanation and solution in this article.<\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_11039\" class=\"pvc_stats all  \" data-element-id=\"11039\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>In this article, I will describe a few of the most known types and solutions of this error. Possible Errors Transaction Log is Full Due To LOG_BACKUP Transaction Log is Full Due To ACTIVE TRANSACTION Transaction Log is Full Due To REPLICATION You can see why the Transaction Log file is FULL with the following &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_11039\" class=\"pvc_stats all  \" data-element-id=\"11039\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":11049,"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":[2880,2883,3096,3095,3097,2881,2882,2870],"class_list":["post-11039","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","tag-active_transaction","tag-full-due-to-log_backup","tag-transaction-log-for-database-is-full-due-to-active_transaction","tag-transaction-log-for-database-is-full-due-to-log_backup","tag-transaction-log-for-database-is-full-due-to-replication","tag-transaction-log-is-full-due-to-active_transaction","tag-transaction-log-is-full-due-to-log_backup","tag-transaction-log-is-full-due-to-replication"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Transaction Log For Database is Full Due To a Reason (ACTIVE_TRANSACTION, LOG_BACKUP, REPLICATION) - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Transaction Log is Full Due To a Reason(ACTIVE_TRANSACTION, LOG_BACKUP, REPLICATION)\" \/>\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\/2019\/03\/26\/transaction-log-for-database-is-full-due-to-a-reason-active-transaction-log-backup-replication\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Transaction Log For Database is Full Due To a Reason (ACTIVE_TRANSACTION, LOG_BACKUP, REPLICATION) - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Transaction Log is Full Due To a Reason(ACTIVE_TRANSACTION, LOG_BACKUP, REPLICATION)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/03\/26\/transaction-log-for-database-is-full-due-to-a-reason-active-transaction-log-backup-replication\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-03-26T07:13:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-10-13T20:32:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/Ads\u0131z-4.png\" \/>\n\t<meta property=\"og:image:width\" content=\"629\" \/>\n\t<meta property=\"og:image:height\" content=\"401\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/26\/transaction-log-for-database-is-full-due-to-a-reason-active-transaction-log-backup-replication\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/26\/transaction-log-for-database-is-full-due-to-a-reason-active-transaction-log-backup-replication\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"Transaction Log For Database is Full Due To a Reason (ACTIVE_TRANSACTION, LOG_BACKUP, REPLICATION)\",\"datePublished\":\"2019-03-26T07:13:22+00:00\",\"dateModified\":\"2020-10-13T20:32:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/26\/transaction-log-for-database-is-full-due-to-a-reason-active-transaction-log-backup-replication\/\"},\"wordCount\":741,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/26\/transaction-log-for-database-is-full-due-to-a-reason-active-transaction-log-backup-replication\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/Ads\u0131z-4.png\",\"keywords\":[\"ACTIVE_TRANSACTION\",\"Full due to Log_backup\",\"transaction log for database is full due to 'active_transaction'\",\"transaction log for database is full due to 'log_backup'\",\"transaction log for database is full due to 'replication'\",\"Transaction Log is Full Due To ACTIVE_TRANSACTION\",\"Transaction Log is Full Due To LOG_BACKUP\",\"Transaction Log is Full Due To replication\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/03\/26\/transaction-log-for-database-is-full-due-to-a-reason-active-transaction-log-backup-replication\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/26\/transaction-log-for-database-is-full-due-to-a-reason-active-transaction-log-backup-replication\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/26\/transaction-log-for-database-is-full-due-to-a-reason-active-transaction-log-backup-replication\/\",\"name\":\"Transaction Log For Database is Full Due To a Reason (ACTIVE_TRANSACTION, LOG_BACKUP, REPLICATION) - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/26\/transaction-log-for-database-is-full-due-to-a-reason-active-transaction-log-backup-replication\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/26\/transaction-log-for-database-is-full-due-to-a-reason-active-transaction-log-backup-replication\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/Ads\u0131z-4.png\",\"datePublished\":\"2019-03-26T07:13:22+00:00\",\"dateModified\":\"2020-10-13T20:32:38+00:00\",\"description\":\"Transaction Log is Full Due To a Reason(ACTIVE_TRANSACTION, LOG_BACKUP, REPLICATION)\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/26\/transaction-log-for-database-is-full-due-to-a-reason-active-transaction-log-backup-replication\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/03\/26\/transaction-log-for-database-is-full-due-to-a-reason-active-transaction-log-backup-replication\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/26\/transaction-log-for-database-is-full-due-to-a-reason-active-transaction-log-backup-replication\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/Ads\u0131z-4.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/Ads\u0131z-4.png\",\"width\":629,\"height\":401},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/26\/transaction-log-for-database-is-full-due-to-a-reason-active-transaction-log-backup-replication\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Transaction Log For Database is Full Due To a Reason (ACTIVE_TRANSACTION, LOG_BACKUP, REPLICATION)\"}]},{\"@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\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Transaction Log For Database is Full Due To a Reason (ACTIVE_TRANSACTION, LOG_BACKUP, REPLICATION) - Database Tutorials","description":"Transaction Log is Full Due To a Reason(ACTIVE_TRANSACTION, LOG_BACKUP, REPLICATION)","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\/2019\/03\/26\/transaction-log-for-database-is-full-due-to-a-reason-active-transaction-log-backup-replication\/","og_locale":"en_US","og_type":"article","og_title":"Transaction Log For Database is Full Due To a Reason (ACTIVE_TRANSACTION, LOG_BACKUP, REPLICATION) - Database Tutorials","og_description":"Transaction Log is Full Due To a Reason(ACTIVE_TRANSACTION, LOG_BACKUP, REPLICATION)","og_url":"https:\/\/dbtut.com\/index.php\/2019\/03\/26\/transaction-log-for-database-is-full-due-to-a-reason-active-transaction-log-backup-replication\/","og_site_name":"Database Tutorials","article_published_time":"2019-03-26T07:13:22+00:00","article_modified_time":"2020-10-13T20:32:38+00:00","og_image":[{"width":629,"height":401,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/Ads\u0131z-4.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/26\/transaction-log-for-database-is-full-due-to-a-reason-active-transaction-log-backup-replication\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/26\/transaction-log-for-database-is-full-due-to-a-reason-active-transaction-log-backup-replication\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"Transaction Log For Database is Full Due To a Reason (ACTIVE_TRANSACTION, LOG_BACKUP, REPLICATION)","datePublished":"2019-03-26T07:13:22+00:00","dateModified":"2020-10-13T20:32:38+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/26\/transaction-log-for-database-is-full-due-to-a-reason-active-transaction-log-backup-replication\/"},"wordCount":741,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/26\/transaction-log-for-database-is-full-due-to-a-reason-active-transaction-log-backup-replication\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/Ads\u0131z-4.png","keywords":["ACTIVE_TRANSACTION","Full due to Log_backup","transaction log for database is full due to 'active_transaction'","transaction log for database is full due to 'log_backup'","transaction log for database is full due to 'replication'","Transaction Log is Full Due To ACTIVE_TRANSACTION","Transaction Log is Full Due To LOG_BACKUP","Transaction Log is Full Due To replication"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/03\/26\/transaction-log-for-database-is-full-due-to-a-reason-active-transaction-log-backup-replication\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/26\/transaction-log-for-database-is-full-due-to-a-reason-active-transaction-log-backup-replication\/","url":"https:\/\/dbtut.com\/index.php\/2019\/03\/26\/transaction-log-for-database-is-full-due-to-a-reason-active-transaction-log-backup-replication\/","name":"Transaction Log For Database is Full Due To a Reason (ACTIVE_TRANSACTION, LOG_BACKUP, REPLICATION) - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/26\/transaction-log-for-database-is-full-due-to-a-reason-active-transaction-log-backup-replication\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/26\/transaction-log-for-database-is-full-due-to-a-reason-active-transaction-log-backup-replication\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/Ads\u0131z-4.png","datePublished":"2019-03-26T07:13:22+00:00","dateModified":"2020-10-13T20:32:38+00:00","description":"Transaction Log is Full Due To a Reason(ACTIVE_TRANSACTION, LOG_BACKUP, REPLICATION)","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/26\/transaction-log-for-database-is-full-due-to-a-reason-active-transaction-log-backup-replication\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/03\/26\/transaction-log-for-database-is-full-due-to-a-reason-active-transaction-log-backup-replication\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/26\/transaction-log-for-database-is-full-due-to-a-reason-active-transaction-log-backup-replication\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/Ads\u0131z-4.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/Ads\u0131z-4.png","width":629,"height":401},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/26\/transaction-log-for-database-is-full-due-to-a-reason-active-transaction-log-backup-replication\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Transaction Log For Database is Full Due To a Reason (ACTIVE_TRANSACTION, LOG_BACKUP, REPLICATION)"}]},{"@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\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/11039","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=11039"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/11039\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/11049"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=11039"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=11039"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=11039"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}