{"id":8596,"date":"2019-04-26T16:13:29","date_gmt":"2019-04-26T16:13:29","guid":{"rendered":"https:\/\/ittutorial.org\/?p=8596"},"modified":"2020-08-27T14:56:04","modified_gmt":"2020-08-27T14:56:04","slug":"sql-server-log-shipping-disaster-recovery-install-and-configuration-3","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/sql-server-log-shipping-disaster-recovery-install-and-configuration-3\/","title":{"rendered":"SQL Server Log Shipping &#038; Disaster Recovery Install and Configuration -3"},"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-8598\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/04\/Log-Shipping2.png\" alt=\"\" width=\"752\" height=\"418\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/04\/Log-Shipping2.png 752w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/04\/Log-Shipping2-300x167.png 300w\" sizes=\"auto, (max-width: 752px) 100vw, 752px\" \/><\/p>\n<p><!--more--><\/p>\n<p>&nbsp;<\/p>\n<p>Read previous article before this.<\/p>\n<p>https:\/\/ittutorial.org\/sql-server-log-shipping-install-and-configuration-2\/<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>In this step let&#8217;s start the Log Shipping Configuration. The screenshot of the steps\u00a0are as follows.<\/p>\n<p>&nbsp;<\/p>\n\n<p>&nbsp;<\/p>\n<p>Right-click the TestDatabase and go to the Transaction Log Shipping menu on the Properties tab as shown in the following image, enable this database for Log Shipping Configuration.<\/p>\n<p><a href=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/83.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3140\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/83.png\" alt=\"8\" width=\"614\" height=\"552\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/83.png 703w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/83-300x270.png 300w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n\n<p>&nbsp;<\/p>\n<p>Create a Transaction Log Backup job as follows, and specify a Schedule as follows. Specify Backup job as every 1 minute intervals and delete files older than 15 min like following.<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/91.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3141\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/91.png\" alt=\"9\" width=\"614\" height=\"649\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/91.png 704w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/91-283x300.png 283w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n\n<p><a href=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/102.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3142\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/102.png\" alt=\"10\" width=\"614\" height=\"537\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/102.png 666w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/102-300x263.png 300w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>create a Share folder that can be accessed by Secondary Server on the primary server and write it to the following paths.<\/p>\n<p>&nbsp;<\/p>\n\n<p>&nbsp;<\/p>\n<p><a href=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/112.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3143\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/112.png\" alt=\"11\" width=\"614\" height=\"630\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/112.png 632w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/112-292x300.png 292w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Configure Transaction Log Backup job on the Primary Database and click the OK button.<\/p>\n<p>&nbsp;<\/p>\n\n<p>&nbsp;<\/p>\n<p>I will continue to 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":8598,"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,2674,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-8596","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-linux-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-Shipping2.png","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/8596","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=8596"}],"version-history":[{"count":6,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/8596\/revisions"}],"predecessor-version":[{"id":18218,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/8596\/revisions\/18218"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media\/8598"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=8596"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=8596"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=8596"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}