This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 2%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELR%3C/text%3E%3C/svg%3E)
Hello All.
SQL Server 2008 Not supporting the URL Backup.
Is there any other best practice to Move SQL Full and Diff backup to Azure storage account. I Have used the below mentioned tool which is not convenient for our environment. Please advice on this.
Tool:
SQL to Azure - https://www.microsoft.com/en-in/download/details.aspx?id=40740
Maintenance Plan details as below:
Full Backup every Sunday
Diff Backup every day
Regards,
Loganathan. R
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
Hi @Loganathan R ,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
You can use PowerShell script + AzCopy to copy any file like SQL backup to Azure Blob Storage.
See
https://cloud.netapp.com/blog/azure-cvo-blg-how-to-upload-files-to-azure-blob-storage
https://argonsys.com/microsoft-cloud/library/how-to-upload-files-to-azure-blob-storage-using-powershell-and-azcopy/
Hello,
This looks lot of Manual intervention. Is there any Option to make the process automated.
Thanks in advance.
Loganathan. R
Hi @Loganathan R ,
SQL Server 2008 is a too old version.
Could you update it to the latest version and try this official tool again?
As for Maintenance Plan, please refer to this article which describes the details about Create a Maintenance Plan for Full & Diff backups.
Best regards,
Seeya
If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hello Seeya,
Yes, We are aware of that.
We also have a plan to upgrade in few months. But as of now we need to upload the database to Azure for that i'm looking for an Option.
Do you have any idea?
Regards,
Logananthan. R
Hi @ LoganathanR-0963 ,
Please refer to this Tutorial to Migrate SQL Server to Azure SQL Database using DMS.
According to Prerequisites, you need to update SQL Server first.
Procedure to upgrade SQL Server: https://learn.microsoft.com/en-us/sql/database-engine/install-windows/upgrade-sql-server-using-the-installation-wizard-setup?view=sql-server-ver15
Best regards,
Seeya