{"id":6622,"date":"2018-12-16T09:21:27","date_gmt":"2018-12-16T09:21:27","guid":{"rendered":"https:\/\/dbtut.com\/?p=6622"},"modified":"2018-12-21T13:06:49","modified_gmt":"2018-12-21T13:06:49","slug":"the-tail-of-the-log-for-the-database-database_name-has-not-been-backed-up","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/the-tail-of-the-log-for-the-database-database_name-has-not-been-backed-up\/","title":{"rendered":"The tail of the log for the database “database_name” has not been backed up"},"content":{"rendered":"

 <\/p>\n

ERROR MESSAGE:<\/h3>\n

Msg 3159, Level 16, State 1, Line 2
\nThe tail of the log for the database “TestDB” has not been backed up. Use BACKUP LOG WITH NORECOVERY to backup the log if it contains work you do not want to lose. Use the WITH REPLACE or WITH STOPAT clause of the RESTORE statement to just overwrite the contents of the log.
\nMsg 3013, Level 16, State 1, Line 2
\nRESTORE DATABASE is terminating abnormally.<\/p>\n

EXPLANATION:<\/h3>\n

You receive this error message when you try to restore a database.<\/p>\n

The reason for the error is that the backup file that you are trying to restore is older than the database you are trying to restore.<\/p>\n

For example, you took a backup of your database named “TestDB” on December 22, 2007. After that there were some changes on the database. On the 23rd of the month, you wanted to restore the backup you received on the 22nd of the month over the “TestDB” database for some reason. That’s when you get this error.<\/p>\n

SOLUTION:<\/h3>\n

In fact, this is some kind of protection system. The intention is to prevent your old data from being overwritten by your new data and this feature came with SQL Server 2005.<\/p>\n

You can use two methods to overcome this protection system (which actually tells the solution within the warning message).<\/p>\n

Method 1:<\/strong> You can restore your database to the current database by using the most up-to-date Log backup of your database (using the NO_TRUNCATE and NORECOVERY parameters).<\/p>\n

Method 2:<\/strong> In this method, you can restore your old backup to your current database using the REPLACE parameter together with the RESTORE command (with no backups). What you should consider about this method is that all changes made to your database will be lost after the date you took this restored backup.<\/p>\n

Note:<\/strong> In later versions of SQL Server, if you want to do this through SSMS, you will see an alert as follows.<\/p>\n

A tail-log backup of the source database will be taken. View this setting on the Options page.<\/p>\n

<\/p>\n

 <\/p>\n

When we switch to Options tab we will see a screen as below.\u00a0As you can see, it is designed to automatically take the tail log backup for protection purposes before Restore. If you uncheck the “Take tail-log backup before restore”, you get the error that is subject to the article.<\/p>\n

<\/p>\n\n

<\/div>\n

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

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

  ERROR MESSAGE: Msg 3159, Level 16, State 1, Line 2 The tail of the log for the database “TestDB” has not been backed up. Use BACKUP LOG WITH NORECOVERY to backup the log if it contains work you do not want to lose. Use the WITH REPLACE or WITH STOPAT clause of the RESTORE …<\/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":[1576],"class_list":["post-6622","post","type-post","status-publish","format-standard","","category-mssql","tag-a-tail-log-backup-of-the-source-database-will-be-taken"],"aioseo_notices":[],"yoast_head":"\nThe tail of the log for the database "database_name" has not been backed up - Database Tutorials<\/title>\n<meta name=\"description\" content=\"The tail of the log for the database "database_name" has not been backed up\" \/>\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\/16\/the-tail-of-the-log-for-the-database-database_name-has-not-been-backed-up\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The tail of the log for the database "database_name" has not been backed up - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"The tail of the log for the database "database_name" has not been backed up\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/the-tail-of-the-log-for-the-database-database_name-has-not-been-backed-up\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-12-16T09:21:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-12-21T13:06:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/220-1.png\" \/>\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=\"2 minutes\" \/>\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\/16\/the-tail-of-the-log-for-the-database-database_name-has-not-been-backed-up\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/the-tail-of-the-log-for-the-database-database_name-has-not-been-backed-up\/\"},\"author\":{\"name\":\"Ekrem \u00d6nsoy\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/42a3e874ed0bf8053fa123a3a1f6ee46\"},\"headline\":\"The tail of the log for the database “database_name” has not been backed up\",\"datePublished\":\"2018-12-16T09:21:27+00:00\",\"dateModified\":\"2018-12-21T13:06:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/the-tail-of-the-log-for-the-database-database_name-has-not-been-backed-up\/\"},\"wordCount\":402,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/the-tail-of-the-log-for-the-database-database_name-has-not-been-backed-up\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/220-1.png\",\"keywords\":[\"A tail-log backup of the source database will be taken\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/the-tail-of-the-log-for-the-database-database_name-has-not-been-backed-up\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/the-tail-of-the-log-for-the-database-database_name-has-not-been-backed-up\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/the-tail-of-the-log-for-the-database-database_name-has-not-been-backed-up\/\",\"name\":\"The tail of the log for the database \\\"database_name\\\" has not been backed up - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/the-tail-of-the-log-for-the-database-database_name-has-not-been-backed-up\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/the-tail-of-the-log-for-the-database-database_name-has-not-been-backed-up\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/220-1.png\",\"datePublished\":\"2018-12-16T09:21:27+00:00\",\"dateModified\":\"2018-12-21T13:06:49+00:00\",\"description\":\"The tail of the log for the database \\\"database_name\\\" has not been backed up\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/the-tail-of-the-log-for-the-database-database_name-has-not-been-backed-up\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/the-tail-of-the-log-for-the-database-database_name-has-not-been-backed-up\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/the-tail-of-the-log-for-the-database-database_name-has-not-been-backed-up\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/220-1.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/220-1.png\",\"width\":735,\"height\":770},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/the-tail-of-the-log-for-the-database-database_name-has-not-been-backed-up\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The tail of the log for the database “database_name” has not been backed up\"}]},{\"@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 tail of the log for the database \"database_name\" has not been backed up - Database Tutorials","description":"The tail of the log for the database \"database_name\" has not been backed up","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\/16\/the-tail-of-the-log-for-the-database-database_name-has-not-been-backed-up\/","og_locale":"en_US","og_type":"article","og_title":"The tail of the log for the database \"database_name\" has not been backed up - Database Tutorials","og_description":"The tail of the log for the database \"database_name\" has not been backed up","og_url":"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/the-tail-of-the-log-for-the-database-database_name-has-not-been-backed-up\/","og_site_name":"Database Tutorials","article_published_time":"2018-12-16T09:21:27+00:00","article_modified_time":"2018-12-21T13:06:49+00:00","og_image":[{"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/220-1.png","type":"","width":"","height":""}],"author":"Ekrem \u00d6nsoy","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Ekrem \u00d6nsoy","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/the-tail-of-the-log-for-the-database-database_name-has-not-been-backed-up\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/the-tail-of-the-log-for-the-database-database_name-has-not-been-backed-up\/"},"author":{"name":"Ekrem \u00d6nsoy","@id":"https:\/\/dbtut.com\/#\/schema\/person\/42a3e874ed0bf8053fa123a3a1f6ee46"},"headline":"The tail of the log for the database “database_name” has not been backed up","datePublished":"2018-12-16T09:21:27+00:00","dateModified":"2018-12-21T13:06:49+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/the-tail-of-the-log-for-the-database-database_name-has-not-been-backed-up\/"},"wordCount":402,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/the-tail-of-the-log-for-the-database-database_name-has-not-been-backed-up\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/220-1.png","keywords":["A tail-log backup of the source database will be taken"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/12\/16\/the-tail-of-the-log-for-the-database-database_name-has-not-been-backed-up\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/the-tail-of-the-log-for-the-database-database_name-has-not-been-backed-up\/","url":"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/the-tail-of-the-log-for-the-database-database_name-has-not-been-backed-up\/","name":"The tail of the log for the database \"database_name\" has not been backed up - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/the-tail-of-the-log-for-the-database-database_name-has-not-been-backed-up\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/the-tail-of-the-log-for-the-database-database_name-has-not-been-backed-up\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/220-1.png","datePublished":"2018-12-16T09:21:27+00:00","dateModified":"2018-12-21T13:06:49+00:00","description":"The tail of the log for the database \"database_name\" has not been backed up","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/the-tail-of-the-log-for-the-database-database_name-has-not-been-backed-up\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/12\/16\/the-tail-of-the-log-for-the-database-database_name-has-not-been-backed-up\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/the-tail-of-the-log-for-the-database-database_name-has-not-been-backed-up\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/220-1.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/220-1.png","width":735,"height":770},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/the-tail-of-the-log-for-the-database-database_name-has-not-been-backed-up\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"The tail of the log for the database “database_name” has not been backed up"}]},{"@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\/6622","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=6622"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/6622\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=6622"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=6622"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=6622"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}