{"id":814,"date":"2022-08-24T11:38:41","date_gmt":"2022-08-24T11:38:41","guid":{"rendered":"http:\/\/markedcode.com\/?p=814"},"modified":"2023-12-22T16:32:30","modified_gmt":"2023-12-22T16:32:30","slug":"sql-backup-to-azure","status":"publish","type":"post","link":"https:\/\/markedcode.com\/index.php\/2022\/08\/24\/sql-backup-to-azure\/","title":{"rendered":"D365 – Recurring Tier1 Backup to Azure Storage Account"},"content":{"rendered":"\n

This document will give a quick description for how to set up recurring SQL DB backups from a Tier 1 environment to an Azure storage account.<\/p>\n\n\n\n

Sign into your Tier 1 environment and run SQL Server Management Studio (SSMS) as Admin. Connect to your server.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Right click the AxDB data base and select Tasks > Back Up \u2026<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Keep the source information the same and set the destination information to back up to \u2018URL\u2019. Click \u2018Add\u2019<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Select \u2018New container\u2019<\/p>\n\n\n\n

    \n
  1. You will be prompted to log into your Microsoft account with the Azure storage container you wish to send the back up too.<\/li>\n\n\n\n
  2. In the drop down select the storage account followed by the blob container<\/li>\n<\/ol>\n\n\n\n
    \"\"<\/figure>\n\n\n\n

    Click \u2018Create Credential\u2019<\/p>\n\n\n\n

      \n
    1. This will generate a Shared Access Signature<\/li>\n\n\n\n
    2. Click \u2018OK\u2019<\/li>\n<\/ol>\n\n\n\n
      \"\"<\/figure>\n\n\n\n

      Click \u2018Ok\u2019 again and you will see your URL in the destination block.<\/p>\n\n\n\n

      Optional<\/b>:<\/p>\n\n\n\n

        \n
      1. Under \u2018Backup Options\u2019 change \u2018Set backup compression\u2019 to \u2018Compress backup\u2019<\/li>\n<\/ol>\n\n\n\n
        \"\"<\/figure>\n\n\n\n

        Under the \u2018General\u2019 tab, select the \u2018Script\u2019 drop down.<\/p>\n\n\n\n

          \n
        1. Choose \u2018Script Action to Job\u2019<\/li>\n<\/ol>\n\n\n\n
          \"\"<\/figure>\n\n\n\n

          On the left hand side, click \u2018Schedules\u2019<\/p>\n\n\n\n

            \n
          1. Then click \u2018New\u2019<\/li>\n\n\n\n
          2. Rename the schedule to \u2018Daily\u2019<\/li>\n\n\n\n
          3. Set the occurrence to \u2018Daily\u2019<\/li>\n\n\n\n
          4. Set the desired time for the backup to occur. Here I will set it to run each day at 9:00 PM. This will use the time of the local machine.<\/li>\n\n\n\n
          5. Click \u2018OK\u2019<\/li>\n<\/ol>\n\n\n\n
            \"\"<\/figure>\n\n\n\n

            Click \u2018Ok\u2019. You should see in the bottom left hand corner that \u2018Scripting completed successfully\u2019. Click \u2018Ok\u2019.<\/p>\n\n\n\n

              \n
            1. This will execute the job. We are not done with our configurations but a backup will be taken at this time and placed on the Azure storage account container you selected.<\/li>\n<\/ol>\n\n\n\n
              \"\"<\/figure>\n\n\n\n

              After clicking \u2018OK\u2019 you should see that the back up successfully completed.<\/p>\n\n\n\n

              \"\"<\/figure>\n\n\n\n

              On the right hand side, under \u2018Jobs\u2019, find your job \u2018Back Up Database \u2013 AxDB\u2019.<\/p>\n\n\n\n

                \n
              1. Right click and choose properties.<\/li>\n\n\n\n
              2. Ensure your SQL Server Agent is running. (See optional step below to automate this process.<\/li>\n<\/ol>\n\n\n\n
                \"\"<\/figure>\n\n\n\n

                Click \u2018Steps\u2019 in the left hand column. Then click \u2018Edit\u2019<\/p>\n\n\n\n