{"id":23,"date":"2011-08-24T21:49:55","date_gmt":"2011-08-24T21:49:55","guid":{"rendered":"http:\/\/www.sqlfreelancer.com\/blog\/?p=23"},"modified":"2014-03-01T02:19:59","modified_gmt":"2014-03-01T02:19:59","slug":"sql-server-log-shipping","status":"publish","type":"post","link":"https:\/\/www.sqlfreelancer.com\/blog\/sql-server-log-shipping\/","title":{"rendered":"SQL Server Log Shipping"},"content":{"rendered":"

Backup Database on Primary Server:<\/p>\n

\"SQL<\/a>Restore Database on Secondary Server: (RESTORE WITH STANDBY)<\/p>\n

\"SQL<\/a>(Picture of Object Explorer once restore is complete)<\/p>\n

\"SQL<\/a>Create a shared folder on the primary server (SQL Server Agent service account must have read\/write permissions):<\/p>\n

\"SQL<\/a>Create a shared folder on the secondary server (SQL Server Agent service account must have read\/write permissions):<\/p>\n

\"SQL<\/a>Enable Log Shipping at the Publisher:<\/p>\n

\"SQL<\/a>Click \u201cEnable this as a primary database in a log shipping configuration\u201d, then click Backup Settings:<\/p>\n

\"SQL<\/a><\/p>\n

    \n
  1. Enter Network Share on Primary Server<\/li>\n
  2. Enter Local Folder path on Primary Server<\/li>\n
  3. Enter the number of Minutes, Hours, or Days to keep the deleted files and to Alert if no backup occurs<\/li>\n
  4. Name the SQL Agent Job and determine a schedule to backup the log files<\/li>\n<\/ol>\n

    \"SQL<\/a><\/p>\n

    Click OK<\/p>\n

    Click Add to add a secondary server:<\/p>\n

    \"SQL<\/a>Click Connect to connect to the secondary server:<\/p>\n

    \"SQL<\/a><\/p>\n

    Select No, since we initialized the database in the beginning by restoring in Standby Mode, otherwise you can choose one of the other options. Hit OK.<\/p>\n

    Go to next tab, Copy Files.<\/p>\n

      \n
    1. Enter Local Folder Path on Secondary server<\/li>\n
    2. Enter the number of Minutes, Hours, or Days to delete copied files<\/li>\n
    3. Name the SQL Agent Job and determine a schedule to copy the log files<\/li>\n<\/ol>\n

      \"SQL<\/a>Go to next tab, Restore Transaction Log.<\/p>\n

        \n
          \n
        1. Since we put the database in Standby\/Read Only mode select Standby Mode<\/li>\n
        2. If you would like to delay restoring the transaction log you can enter a value in the \u201cDelay restoring backups at least\u201d otherwise leave at 0 minutes.
          \nEnter the number of Minutes, Hours, or Days to Alert if no restore occurs<\/li>\n
        3. Name the SQL Agent Job and determine a schedule to restore the log files<\/li>\n<\/ol>\n<\/ol>\n

          \"SQL<\/a><\/p>\n

          Hit OK<\/p>\n

          **OPTIONAL** To create a monitor server click \u201cUse monitor server instance\u201d and then click Settings<\/p>\n

          \"SQL<\/a><\/p>\n

            \n
              \n
            1. Click Connect to connect to a monitor server instance<\/li>\n
            2. Select the login method you would like to use to connect to the monitor server.<\/li>\n
            3. Enter the number of Minutes, Hours, or Days to delete log file data<\/li>\n
            4. Name the SQL Agent Job and determine a schedule to for the alert task<\/li>\n<\/ol>\n<\/ol>\n

              \"SQL<\/a>Hit OK twice.<\/p>\n

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

              Backup Database on Primary Server: Restore Database on Secondary Server: (RESTORE WITH STANDBY) (Picture of Object Explorer once restore is complete) Create a shared folder on the primary server (SQL Server Agent service account must have read\/write permissions): Create a shared folder on the secondary server (SQL Server Agent service account must have read\/write permissions): […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[100,13],"tags":[14,7,99],"class_list":["post-23","post","type-post","status-publish","format-standard","hentry","category-high-availability","category-log-shipping","tag-backuprestore","tag-high-availability","tag-log-shipping"],"_links":{"self":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts\/23","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/comments?post=23"}],"version-history":[{"count":3,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts\/23\/revisions"}],"predecessor-version":[{"id":86,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts\/23\/revisions\/86"}],"wp:attachment":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/media?parent=23"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/categories?post=23"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/tags?post=23"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}