{"id":1151,"date":"2007-10-12T19:26:00","date_gmt":"2007-10-12T19:26:00","guid":{"rendered":"\/blogs\/paul\/post\/SQL-Server-2008-Whats-been-removed-in-this-version-BACKUP-LOG-WITH-NO_LOG-for-one!.aspx"},"modified":"2013-01-01T19:21:59","modified_gmt":"2013-01-02T03:21:59","slug":"sql-server-2008-whats-been-removed-in-this-version-backup-log-with-no_log-for-one","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2008-whats-been-removed-in-this-version-backup-log-with-no_log-for-one\/","title":{"rendered":"SQL Server 2008: What’s been removed in this version? BACKUP LOG WITH NO_LOG for one!"},"content":{"rendered":"

<\/p>\n

\nAll the razzamatazz about new releases go on about what's new but hardly ever is there discussion of what's been removed<\/em>. So that's the topic of this short post.\n<\/p>\n

\nIn the Books Online that comes with the July CTP of SS2008 (here's<\/font><\/strong><\/a> a link to the download page), the topic Discontinued Database Engine Functionality in SQL Server 2008<\/em> lists the following:\n<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Category <\/font><\/th>\nDiscontinued feature <\/font><\/th>\nReplacement <\/font><\/th>\n<\/tr>\n
\n

\n\t\t\tAliases<\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\tsp_addalias<\/strong> <\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\tReplace aliases with a combination of user accounts and database roles. For more information, see CREATE USER (Transact-SQL) and CREATE ROLE (Transact-SQL). Remove aliases in upgraded databases by using sp_dropalias (Transact-SQL).<\/font>\n\t\t\t<\/p>\n<\/td>\n<\/tr>\n

\n

\n\t\t\tBackup and restore<\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\tDUMP statement<\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\tBACKUP<\/font>\n\t\t\t<\/p>\n<\/td>\n<\/tr>\n

\n

\n\t\t\tBackup and restore<\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\tLOAD statement<\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\tRESTORE<\/font>\n\t\t\t<\/p>\n<\/td>\n<\/tr>\n

\n

\n\t\t\tBackup and restore<\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\tBACKUP LOG WITH NO_LOG<\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\tNone. The transaction log is automatically truncated when the database is using the simple recovery model. If you must remove the log backup chain from a database, switch to the simple recovery model.<\/font>\n\t\t\t<\/p>\n<\/td>\n<\/tr>\n

\n

\n\t\t\tBackup and restore<\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\tBACKUP LOG WITH TRUNCATE_ONLY<\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\tNone. The transaction log is automatically truncated when the database is using the simple recovery model. If you must remove the log backup chain from a database, switch to the simple recovery model.<\/font>\n\t\t\t<\/p>\n<\/td>\n<\/tr>\n

\n

\n\t\t\tBackup and restore<\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\tBACKUP TRANSACTION <\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\tBACKUP LOG<\/font>\n\t\t\t<\/p>\n<\/td>\n<\/tr>\n

\n

\n\t\t\tBackup and restore<\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\tsp_helpdevice<\/strong> <\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\tQuery the sys.backup_devices<\/strong> catalog view.<\/font>\n\t\t\t<\/p>\n<\/td>\n<\/tr>\n

\n

\n\t\t\tCompatibility level<\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\t60, 65, and 70 compatibility levels<\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\tDatabases must be set to at least compatibility level 80.<\/font>\n\t\t\t<\/p>\n<\/td>\n<\/tr>\n

\n

\n\t\t\tDBCC<\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\tDBCC CONCURRENCYVIOLATION<\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\tNone<\/font>\n\t\t\t<\/p>\n<\/td>\n<\/tr>\n

\n

\n\t\t\tGroups<\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\tsp_addgroup<\/strong> <\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\tUse roles.<\/font>\n\t\t\t<\/p>\n<\/td>\n<\/tr>\n

\n

\n\t\t\tGroups<\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\tsp_changegroup<\/strong> <\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\tUse roles.<\/font>\n\t\t\t<\/p>\n<\/td>\n<\/tr>\n

\n

\n\t\t\tGroups<\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\tsp_dropgroup<\/strong> <\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\tUse roles.<\/font>\n\t\t\t<\/p>\n<\/td>\n<\/tr>\n

\n

\n\t\t\tGroups<\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\tsp_helpgroup<\/strong> <\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\tUse roles.<\/font>\n\t\t\t<\/p>\n<\/td>\n<\/tr>\n

\n

\n\t\t\tSample databases<\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\tNorthwind<\/strong> and pubs<\/strong><\/font>\n\t\t\t<\/p>\n<\/td>\n

\n

\n\t\t\tUse AdventureWorks<\/strong>. Northwind<\/strong> and pubs<\/strong> are available as downloads, or can be copied from a previous installation of SQL Server.<\/font>\n\t\t\t<\/p>\n

\n\t\t\tFor more information, see AdventureWorks Sample Databases.<\/font>\n\t\t\t<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\nMost of these aren't going to bother people much I would guess but removing BACKUP LOG WITH NO_LOG<\/font> is going to cause problems. Don't get me wrong, I think it's great that it's being removed (see my previous post<\/a> for why I think it's evil) but it's going to break a lot of people who rely on it now for managing their transaction logs instead of taking log backups or switching to SIMPLE recovery mode.\n<\/p>\n

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

All the razzamatazz about new releases go on about what's new but hardly ever is there discussion of what's been removed. So that's the topic of this short post. In the Books Online that comes with the July CTP of SS2008 (here's a link to the download page), the topic Discontinued Database Engine Functionality in […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,86],"tags":[],"class_list":["post-1151","post","type-post","status-publish","format-standard","hentry","category-backuprestore","category-sql-server-2008"],"yoast_head":"\nSQL Server 2008: What's been removed in this version? BACKUP LOG WITH NO_LOG for one! - Paul S. Randal<\/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:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2008-whats-been-removed-in-this-version-backup-log-with-no_log-for-one\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2008: What's been removed in this version? BACKUP LOG WITH NO_LOG for one! - Paul S. Randal\" \/>\n<meta property=\"og:description\" content=\"All the razzamatazz about new releases go on about what's new but hardly ever is there discussion of what's been removed. So that's the topic of this short post. In the Books Online that comes with the July CTP of SS2008 (here's a link to the download page), the topic Discontinued Database Engine Functionality in […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2008-whats-been-removed-in-this-version-backup-log-with-no_log-for-one\/\" \/>\n<meta property=\"og:site_name\" content=\"Paul S. Randal\" \/>\n<meta property=\"article:published_time\" content=\"2007-10-12T19:26:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2013-01-02T03:21:59+00:00\" \/>\n<meta name=\"author\" content=\"Paul Randal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Paul Randal\" \/>\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\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2008-whats-been-removed-in-this-version-backup-log-with-no_log-for-one\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2008-whats-been-removed-in-this-version-backup-log-with-no_log-for-one\/\",\"name\":\"SQL Server 2008: What's been removed in this version? BACKUP LOG WITH NO_LOG for one! - Paul S. Randal\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\"},\"datePublished\":\"2007-10-12T19:26:00+00:00\",\"dateModified\":\"2013-01-02T03:21:59+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2008-whats-been-removed-in-this-version-backup-log-with-no_log-for-one\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2008-whats-been-removed-in-this-version-backup-log-with-no_log-for-one\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2008-whats-been-removed-in-this-version-backup-log-with-no_log-for-one\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2008: What’s been removed in this version? BACKUP LOG WITH NO_LOG for one!\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\",\"name\":\"Paul S. Randal\",\"description\":\"In Recovery...\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\",\"name\":\"Paul Randal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"caption\":\"Paul Randal\"},\"sameAs\":[\"http:\/\/3.209.169.194\/blogs\/paul\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server 2008: What's been removed in this version? BACKUP LOG WITH NO_LOG for one! - Paul S. Randal","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:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2008-whats-been-removed-in-this-version-backup-log-with-no_log-for-one\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2008: What's been removed in this version? BACKUP LOG WITH NO_LOG for one! - Paul S. Randal","og_description":"All the razzamatazz about new releases go on about what's new but hardly ever is there discussion of what's been removed. So that's the topic of this short post. In the Books Online that comes with the July CTP of SS2008 (here's a link to the download page), the topic Discontinued Database Engine Functionality in […]","og_url":"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2008-whats-been-removed-in-this-version-backup-log-with-no_log-for-one\/","og_site_name":"Paul S. Randal","article_published_time":"2007-10-12T19:26:00+00:00","article_modified_time":"2013-01-02T03:21:59+00:00","author":"Paul Randal","twitter_misc":{"Written by":"Paul Randal","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2008-whats-been-removed-in-this-version-backup-log-with-no_log-for-one\/","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2008-whats-been-removed-in-this-version-backup-log-with-no_log-for-one\/","name":"SQL Server 2008: What's been removed in this version? BACKUP LOG WITH NO_LOG for one! - Paul S. Randal","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website"},"datePublished":"2007-10-12T19:26:00+00:00","dateModified":"2013-01-02T03:21:59+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2008-whats-been-removed-in-this-version-backup-log-with-no_log-for-one\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2008-whats-been-removed-in-this-version-backup-log-with-no_log-for-one\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2008-whats-been-removed-in-this-version-backup-log-with-no_log-for-one\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/paul\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2008: What’s been removed in this version? BACKUP LOG WITH NO_LOG for one!"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/","name":"Paul S. Randal","description":"In Recovery...","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce","name":"Paul Randal","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","caption":"Paul Randal"},"sameAs":["http:\/\/3.209.169.194\/blogs\/paul"],"url":"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/1151","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/comments?post=1151"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/1151\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/media?parent=1151"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/categories?post=1151"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/tags?post=1151"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}