{"id":567,"date":"2011-05-24T11:31:00","date_gmt":"2011-05-24T11:31:00","guid":{"rendered":"\/blogs\/paul\/post\/SQL-Server-Magazine-feature-article-on-advanced-BACKUP-and-RESTORE-options.aspx"},"modified":"2017-08-11T10:19:34","modified_gmt":"2017-08-11T17:19:34","slug":"sql-server-magazine-feature-article-on-advanced-backup-and-restore-options","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-magazine-feature-article-on-advanced-backup-and-restore-options\/","title":{"rendered":"SQL Server Magazine: feature article on advanced BACKUP and RESTORE options"},"content":{"rendered":"<p style=\"text-align: justify;\">The June SQL Server Magazine articles are now available on the web and include my latest feature article on <em>Advanced BACKUP and RESTORE Options<\/em>.<\/p>\n<p style=\"text-align: justify;\">Rather than covering how <em>BACKUP<\/em> and <em>RESTORE<\/em> work or how to perform common backup\/restore operations I decided to show you some of the less commonly used options that can be very helpful. The article covers:<\/p>\n<ul>\n<li>Verifying backup integrity<\/li>\n<li>Tail-of-the-log backups<\/li>\n<li>Using <em>BUFFERCOUNT<\/em> and <em>MAXTRANSFERSIZE<\/em> to tune backup performance<\/li>\n<li>Piecemeal and <em>PARTIAL<\/em> restores<\/li>\n<li>Using marked transactions and <em>STOPATMARK<\/em> and <em>STOPBEFOREMARK<\/em><\/li>\n<li>Restarting an interrupted restore operation<\/li>\n<\/ul>\n<p>You can get to the article <a href=\"http:\/\/sqlmag.com\/database-backup-and-recovery\/advanced-backup-and-restore-options\">HERE<\/a> (no login\u00a0required).<\/p>\n<p>Enjoy!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The June SQL Server Magazine articles are now available on the web and include my latest feature article on Advanced BACKUP and RESTORE Options. Rather than covering how BACKUP and RESTORE work or how to perform common backup\/restore operations I decided to show you some of the less commonly used options that can be very [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,87],"tags":[],"class_list":["post-567","post","type-post","status-publish","format-standard","hentry","category-backuprestore","category-sql-server-magazine"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Server Magazine: feature article on advanced BACKUP and RESTORE options - 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-magazine-feature-article-on-advanced-backup-and-restore-options\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server Magazine: feature article on advanced BACKUP and RESTORE options - Paul S. Randal\" \/>\n<meta property=\"og:description\" content=\"The June SQL Server Magazine articles are now available on the web and include my latest feature article on Advanced BACKUP and RESTORE Options. Rather than covering how BACKUP and RESTORE work or how to perform common backup\/restore operations I decided to show you some of the less commonly used options that can be very [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-magazine-feature-article-on-advanced-backup-and-restore-options\/\" \/>\n<meta property=\"og:site_name\" content=\"Paul S. Randal\" \/>\n<meta property=\"article:published_time\" content=\"2011-05-24T11:31:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-08-11T17:19:34+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=\"1 minute\" \/>\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-magazine-feature-article-on-advanced-backup-and-restore-options\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-magazine-feature-article-on-advanced-backup-and-restore-options\/\",\"name\":\"SQL Server Magazine: feature article on advanced BACKUP and RESTORE options - Paul S. Randal\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\"},\"datePublished\":\"2011-05-24T11:31:00+00:00\",\"dateModified\":\"2017-08-11T17:19:34+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-magazine-feature-article-on-advanced-backup-and-restore-options\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-magazine-feature-article-on-advanced-backup-and-restore-options\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-magazine-feature-article-on-advanced-backup-and-restore-options\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server Magazine: feature article on advanced BACKUP and RESTORE options\"}]},{\"@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 Magazine: feature article on advanced BACKUP and RESTORE options - 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-magazine-feature-article-on-advanced-backup-and-restore-options\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server Magazine: feature article on advanced BACKUP and RESTORE options - Paul S. Randal","og_description":"The June SQL Server Magazine articles are now available on the web and include my latest feature article on Advanced BACKUP and RESTORE Options. Rather than covering how BACKUP and RESTORE work or how to perform common backup\/restore operations I decided to show you some of the less commonly used options that can be very [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-magazine-feature-article-on-advanced-backup-and-restore-options\/","og_site_name":"Paul S. Randal","article_published_time":"2011-05-24T11:31:00+00:00","article_modified_time":"2017-08-11T17:19:34+00:00","author":"Paul Randal","twitter_misc":{"Written by":"Paul Randal","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-magazine-feature-article-on-advanced-backup-and-restore-options\/","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-magazine-feature-article-on-advanced-backup-and-restore-options\/","name":"SQL Server Magazine: feature article on advanced BACKUP and RESTORE options - Paul S. Randal","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website"},"datePublished":"2011-05-24T11:31:00+00:00","dateModified":"2017-08-11T17:19:34+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-magazine-feature-article-on-advanced-backup-and-restore-options\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-magazine-feature-article-on-advanced-backup-and-restore-options\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-magazine-feature-article-on-advanced-backup-and-restore-options\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/paul\/"},{"@type":"ListItem","position":2,"name":"SQL Server Magazine: feature article on advanced BACKUP and RESTORE options"}]},{"@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\/567","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=567"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/567\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/media?parent=567"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/categories?post=567"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/tags?post=567"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}