{"id":520,"date":"2010-04-02T08:48:00","date_gmt":"2010-04-02T15:48:00","guid":{"rendered":"\/blogs\/kimberly\/post\/Backup-Resources-Where-oh-where-can-they-be.aspx"},"modified":"2024-01-19T04:31:11","modified_gmt":"2024-01-19T12:31:11","slug":"backup-resources-where-oh-where-can-they-be","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/backup-resources-where-oh-where-can-they-be\/","title":{"rendered":"Backup Resources &#8211; Where, oh where, can they be?"},"content":{"rendered":"<p>UPDATED: April 20, 2018 (fixed links and removed some outdated content)<\/p>\n<p>A common discussion tends to be around backup\/restore so I&#8217;ve generally found that there just isn&#8217;t a great single place where a bunch of resources are listed. Many of these are my resources or Paul&#8217;s (<a href=\"http:\/\/www.SQLskills.com\/blogs\/kimberly\/\" target=\"_blank\" rel=\"noopener noreferrer\" class=\"broken_link\">blog<\/a>|<a href=\"https:\/\/twitter.com\/PaulRandal\" target=\"_blank\" rel=\"noopener noreferrer\">twitter<\/a>). Enjoy!<\/p>\n<p><span style=\"font-family: verdana,geneva;\"><strong>Classes <\/strong>to learn more about backups and disaster recovery: <\/span><\/p>\n<ul>\n<li>These resources are much more current (best in this order):\n<ul>\n<li>Pluralsight: <a href=\"https:\/\/www.pluralsight.com\/courses\/sqlserver-logging\">SQL Server: Logging, Recovery, and the Transaction Log<\/a><\/li>\n<li>Pluralsight:\u00a0<a href=\"https:\/\/www.pluralsight.com\/courses\/sqlserver-understanding-performing-backups\">SQL Server: Understanding and Performing Backups<\/a><\/li>\n<li>Pluralsight: <a href=\"https:\/\/www.pluralsight.com\/courses\/sqlserver-database-corruption\">SQL Server: Detecting and Correcting Database Corruption<\/a><\/li>\n<li>Pluralsight: <a href=\"https:\/\/www.pluralsight.com\/courses\/sqlserver-advanced-corruption-recovery-techniques\">SQL Server: Advanced Corruption Recovery Techniques<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><span style=\"font-family: verdana,geneva;\"><strong>Whitepapers<\/strong>: <\/span><\/p>\n<ul>\n<li><a href=\"http:\/\/download.microsoft.com\/download\/d\/9\/4\/d948f981-926e-40fa-a026-5bfcf076d9b9\/Technical%20Case%20Study-Backup%20VLDB%20Over%20Network_Final.docx\" target=\"_blank\" rel=\"noopener noreferrer\">A Technical Case Study: Fast and Reliable Backup and Restore of Multi-Terabytes Database over the Network<\/a><\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/previous-versions\/sql\/sql-server-2008\/dd894051(v=sql.100)\" target=\"_blank\" rel=\"noopener noreferrer\">Microsoft SQL Server 2008 Data and Backup Compression\u00a0<\/a><\/li>\n<\/ul>\n<p><strong><span style=\"font-family: verdana,geneva; font-size: medium;\">Articles:<\/span><\/strong><\/p>\n<ul>\n<li><a href=\"http:\/\/technet.microsoft.com\/en-us\/magazine\/2009.02.logging.aspx\" target=\"_blank\" rel=\"noopener noreferrer\">TechNet: Understanding Logging and Recovery in SQL Server<\/a>, written by <a href=\"http:\/\/www.SQLskills.com\/blogs\/paul\/\" target=\"_blank\" rel=\"noopener noreferrer\" class=\"broken_link\">Paul S. Randal<\/a><\/li>\n<li><a href=\"http:\/\/technet.microsoft.com\/en-us\/magazine\/2009.07.sqlbackup.aspx\" target=\"_blank\" rel=\"noopener noreferrer\">TechNet: Understanding SQL Server Backups<\/a>, written by <a href=\"http:\/\/www.SQLskills.com\/blogs\/paul\/\" target=\"_blank\" rel=\"noopener noreferrer\" class=\"broken_link\">Paul S. Randal<\/a><\/li>\n<li><a href=\"http:\/\/technet.microsoft.com\/en-us\/magazine\/ee677581.aspx\" target=\"_blank\" rel=\"noopener noreferrer\">TechNet: SQL Server: Recovering from Disasters Using Backups<\/a>, written by <a href=\"http:\/\/www.SQLskills.com\/blogs\/paul\/\" target=\"_blank\" rel=\"noopener noreferrer\" class=\"broken_link\">Paul S. Randal<\/a><\/li>\n<li>Paul&#8217;s entire TechNet articles series from his blog category <a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/category\/technet-magazine\/\" target=\"_blank\" rel=\"noopener noreferrer\">TechNet Magazine<\/a><\/li>\n<li><a href=\"http:\/\/www.itprotoday.com\/microsoft-sql-server\/recovering-isolated-corruption\" target=\"_blank\" rel=\"noopener noreferrer\">SQL\u00a0Server Magazine: Recovering from Isolated Corruption<\/a>, written by me<\/li>\n<li><a href=\"http:\/\/www.itprotoday.com\/management-mobility\/best-place-bulklogged\" target=\"_blank\" rel=\"noopener noreferrer\">SQL Server Magazine: The Best Place for Bulk_Logged<\/a>, written by me<\/li>\n<\/ul>\n<p><strong><span style=\"font-family: verdana,geneva; font-size: medium;\">Additional blog posts\/topics:<\/span><\/strong><\/p>\n<ul>\n<li><a href=\"http:\/\/sqlblog.com\/blogs\/aaron_bertrand\/archive\/2010\/03\/15\/yes-you-can-benefit-from-both-data-and-backup-compression.aspx\" target=\"_blank\" rel=\"noopener noreferrer\" class=\"broken_link\">Yes, you can benefit from both data and backup compression<\/a> by fellow SQL Server MVP, Aaron Bertrand (<a href=\"http:\/\/sqlblog.com\/blogs\/aaron_bertrand\/default.aspx\" target=\"_blank\" rel=\"noopener noreferrer\" class=\"broken_link\">blog<\/a>|<a href=\"http:\/\/twitter.com\/aaronbertrand\" target=\"_blank\" rel=\"noopener noreferrer\" class=\"broken_link\">twitter<\/a>)<\/li>\n<li>What about maintenance automation? Check out Ola Hallengren&#8217;s &#8220;<em>Backup, Integrity Check and Index Optimization<\/em>&#8221; blog post <a href=\"http:\/\/ola.hallengren.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">here<\/a>.<\/li>\n<li>Paul&#8217;s blog category on backup\/restore <a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/category\/backuprestore\/\" target=\"_blank\" rel=\"noopener noreferrer\">here<\/a>.<\/li>\n<li>Kimberly&#8217;s blog category on backup\/restore <a href=\"https:\/\/www.sqlskills.com\/blogs\/kimberly\/category\/backup-restore\/\" target=\"_blank\" rel=\"noopener noreferrer\">here<\/a>.<\/li>\n<li><a href=\"http:\/\/sqlcat.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">SQLCAT<\/a>: <a href=\"http:\/\/sqlcat.com\/sqlcat\/b\/technicalnotes\/archive\/2008\/04\/21\/tuning-the-performance-of-backup-compression-in-sql-server-2008.aspx\" target=\"_blank\" rel=\"noopener noreferrer\">Tuning the Performance of Backup Compression in SQL Server 2008<\/a><\/li>\n<li><a href=\"http:\/\/sqlcat.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">SQLCAT<\/a>: <a href=\"http:\/\/sqlcat.com\/sqlcat\/b\/technicalnotes\/archive\/2009\/02\/16\/tuning-backup-compression-part-2.aspx\" target=\"_blank\" rel=\"noopener noreferrer\">Tuning Backup Compression Part 2<\/a><\/li>\n<li><a href=\"http:\/\/sqlcat.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">SQLCAT<\/a>: <a href=\"http:\/\/sqlcat.com\/sqlcat\/b\/msdnmirror\/archive\/2008\/03\/02\/backup-more-than-1gb-per-second-using-sql2008-backup-compression.aspx\" target=\"_blank\" rel=\"noopener noreferrer\">Backup More Than 1GB per Second Using SQL2008 Backup Compression<\/a><\/li>\n<li><a href=\"http:\/\/sqlcat.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">SQLCAT<\/a>: <a href=\"http:\/\/sqlcat.com\/sqlcat\/b\/whitepapers\/archive\/2009\/08\/13\/a-technical-case-study-fast-and-reliable-backup-and-restore-of-a-vldb-over-the-network.aspx\" target=\"_blank\" rel=\"noopener noreferrer\">A Technical Case Study: Fast and Reliable Backup and Restore of Multi-Terabytes Database over the Network<\/a><\/li>\n<\/ul>\n<p><strong>Some other interesting issues<\/strong> &#8211; what about the application ecosystem (if you&#8217;re moving to another instance or even another physical server):<\/p>\n<ul>\n<li>\n<div>Logins, etc.? Check out this KB article to help you migrate the logins:\u00a0<a href=\"http:\/\/support.microsoft.com\/kb\/246133\" target=\"_blank\" rel=\"noopener noreferrer\" class=\"broken_link\">How to transfer logins and passwords between instances of SQL Server<\/a>.<\/div>\n<\/li>\n<li>\n<div>What about server-level roles? While the KB article helps you migrate logins to the secondary server &#8211; what about any role membership that you&#8217;ve set? These are NOT migrated! This is something that you may want to prepare beforehand. (thanks to fellow SQL Server MVP, Aaron Bertrand (<a href=\"http:\/\/sqlblog.com\/blogs\/aaron_bertrand\/default.aspx\" target=\"_blank\" rel=\"noopener noreferrer\" class=\"broken_link\">blog<\/a>|<a href=\"http:\/\/twitter.com\/aaronbertrand\" target=\"_blank\" rel=\"noopener noreferrer\" class=\"broken_link\">twitter<\/a>) for the great discussion!)<\/div>\n<\/li>\n<li>\n<div>However, even if you get the logins migrated and the system roles scripted, there any other issues that you could run into! What about jobs, operators, service accounts, external batch files, executables &#8211; anything and everything that&#8217;s not *in* the database but keeps that database &#8220;ticking&#8221; that&#8217;s NOT backed up nor restored (er, except for filestream &#8211; which is external but *IS* backed up by default). So, these are additional things to prepare and test so that your\u00a0disaster recovery strategy succeeds.<\/div>\n<\/li>\n<\/ul>\n<p>So, while there are a lot of great resources out there &#8211; sometimes they can be difficult to find. In fact, it took me a few hours to bring everything together here&#8230; and, in all honesty, there&#8217;s even more out there!<\/p>\n<p>Enjoy!<\/p>\n<p>Thanks for reading,<br \/>\nkt<\/p>\n","protected":false},"excerpt":{"rendered":"<p>UPDATED: April 20, 2018 (fixed links and removed some outdated content) A common discussion tends to be around backup\/restore so I&#8217;ve generally found that there just isn&#8217;t a great single place where a bunch of resources are listed. Many of these are my resources or Paul&#8217;s (blog|twitter). Enjoy! Classes to learn more about backups and [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14,58],"tags":[],"class_list":["post-520","post","type-post","status-publish","format-standard","hentry","category-backup-restore","category-resources"],"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts\/520","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/comments?post=520"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts\/520\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/media?parent=520"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/categories?post=520"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/tags?post=520"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}