{"id":8562,"date":"2019-04-26T15:51:30","date_gmt":"2019-04-26T15:51:30","guid":{"rendered":"https:\/\/ittutorial.org\/?p=8562"},"modified":"2020-08-27T14:55:12","modified_gmt":"2020-08-27T14:55:12","slug":"sql-server-log-shipping-disaster-recovery-install-and-configuration-2","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/sql-server-log-shipping-disaster-recovery-install-and-configuration-2\/","title":{"rendered":"SQL Server Log Shipping &#038; Disaster Recovery Install and Configuration -2"},"content":{"rendered":"<p>Hi,<\/p>\n<p>In this article, I will continue to explain you about Log Shipping technology in SQL Server.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8593\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/04\/Log-Shipping.jpeg\" alt=\"\" width=\"295\" height=\"171\" \/><\/p>\n<p><!--more--><\/p>\n\n<p>&nbsp;<\/p>\n<p>Read previous article before this.<\/p>\n<p>https:\/\/ittutorial.org\/sql-server-log-shipping-install-and-configuration-1\/<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Now let&#8217;s install Log Shipping via a sample database and visually explain the implementation of Log Shipping. Before starting installation, we can determine the pre-requirements for Log Shipping as follows.<\/p>\n<p>&nbsp;<\/p>\n<ol>\n<li>Recovery Model must be either <span style=\"color: #ff0000;\">Full or Bulk-Logged<\/span> in the primary database.<\/li>\n<li>There must be a shared folder on the Primary server\u00a0that the Secondary Server can access. Transaction log backups will be kept in the shared folder and the secondary server will copy these files and restore the backups.<\/li>\n<li>The user to perform the Log Shipping configuration must be sysadmin role.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p>The SQL Server Instance and the status of the Log Shipping process are as follows.<\/p>\n<p>Log Shipping i\u015flemini ger\u00e7ekle\u015ftirece\u011fimiz SQL Server Instance lar\u0131 ve stat\u00fcleri a\u015fa\u011f\u0131daki gibidir.<\/p>\n<p><strong>Primary (Production) Database:<\/strong> MYTESTINSTANCE<\/p>\n<p><strong>Secondary (Standby) Database<\/strong>: TEST2008R2<\/p>\n<p>&nbsp;<\/p>\n<p>After complete the requirements,\u00a0 now start installation of Log Shipping. I&#8217;m creating a sample database and\u00a0table called TestDatabase, TestTable.<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/18.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3134\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/18.png\" alt=\"1\" width=\"614\" height=\"264\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/18.png 986w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/18-300x129.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/18-768x331.png 768w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Insert sample data into the TestTable table as below for log shipping testing.<\/p>\n<p><a href=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/211.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3135\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/211.png\" alt=\"2\" width=\"340\" height=\"282\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/211.png 340w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/211-300x249.png 300w\" sizes=\"auto, (max-width: 340px) 100vw, 340px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Before starting installation of Log Shipping, we will follow the steps as following.<\/p>\n<ol>\n<li>Take Full Backup of the primary database and restore\u00a0this backup on the Secondary Server in NoRecovery Mode.<\/li>\n<li>Perform the Log Shipping Configuration.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p>Take full backup of primary database like following.<\/p>\n<p><a href=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/33.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3136\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/33.png\" alt=\"3\" width=\"614\" height=\"339\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/33.png 633w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/33-300x166.png 300w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Restore\u00a0this backup on the Secondary Server in NoRecovery Mode.<br \/>\n<a href=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/61.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3138\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/61.png\" alt=\"6\" width=\"614\" height=\"255\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/61.png 1007w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/61-300x125.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/61-768x320.png 768w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Take Transaction log backup of primary database like following.<\/p>\n<p><a href=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/42.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3137\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/42.png\" alt=\"4\" width=\"598\" height=\"202\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/42.png 598w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/42-300x101.png 300w\" sizes=\"auto, (max-width: 598px) 100vw, 598px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Restore\u00a0this backup on the Secondary Server in NoRecovery Mode.<\/p>\n<p><a href=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/72.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3139\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/72.png\" alt=\"7\" width=\"614\" height=\"160\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/72.png 971w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/72-300x78.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/72-768x201.png 768w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>I will explain the configuration of Log Shipping in the Next article.<\/p>\n<p>&nbsp;<\/p>\n<h4><span style=\"color: #ff0000;\">Do you want to learn Microsoft SQL Server DBA Tutorials for Beginners, then read the following articles.<\/span><\/h4>\n<p><a href=\"https:\/\/ittutorial.org\/sql-server-tutorials-microsoft-database-for-beginners\/\">https:\/\/ittutorial.org\/sql-server-tutorials-microsoft-database-for-beginners\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi, In this article, I will continue to explain you about Log Shipping technology in SQL Server.<\/p>\n","protected":false},"author":1,"featured_media":8593,"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,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[2227],"tags":[460,2672,508,3898,2671,1000,3899,3901,3900,1031,1515,1577,1632,1647,1653,12709,12708,12707,3902,3903,12706,12705,12704,12703,12702,12701,2620],"class_list":["post-8562","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-sql-server-2","tag-database-high-availability","tag-database-tutorial","tag-deveci","tag-how-to-install-log-shipping","tag-it-tutorial","tag-log-shipping","tag-log-shipping-install","tag-log-shipping-install-sql-server","tag-logshipping-install","tag-mehmet-salih-deveci","tag-salih-deveci","tag-sql-server","tag-sql-server-disaster-recovery","tag-sql-server-high-availability","tag-sql-server-log-shipping","tag-sql-server-log-shipping-configuration","tag-sql-server-log-shipping-for-reporting","tag-sql-server-log-shipping-from-2008-to-2019","tag-sql-server-log-shipping-install","tag-sql-server-log-shipping-installation","tag-sql-server-log-shipping-licensing","tag-sql-server-log-shipping-limitations","tag-sql-server-log-shipping-monitor-script","tag-sql-server-log-shipping-vs-always-on","tag-sql-server-log-shipping-vs-mirroring","tag-sql-server-log-shipping-vs-replication","tag-sql-server-tutorial"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/04\/Log-Shipping.jpeg","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/8562","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=8562"}],"version-history":[{"count":8,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/8562\/revisions"}],"predecessor-version":[{"id":18217,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/8562\/revisions\/18217"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media\/8593"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=8562"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=8562"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=8562"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}