question

LoganathanR-0963 avatar image
0 Votes"
LoganathanR-0963 asked SeeyaXi-msft commented

Moving SQL Full & Diff Bakup to Azure blob Storage Account | SQL Server 2008

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

sql-server-generalazure-sql-database
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @LoganathanR-0963 ,

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.

0 Votes 0 ·
OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered LoganathanR-0963 commented
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello,
This looks lot of Manual intervention. Is there any Option to make the process automated.

Thanks in advance.
Loganathan. R

0 Votes 0 ·
SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered SeeyaXi-msft commented

Hi @LoganathanR-0963 ,

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.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

0 Votes 0 ·

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://docs.microsoft.com/en-us/sql/database-engine/install-windows/upgrade-sql-server-using-the-installation-wizard-setup?view=sql-server-ver15

Best regards,
Seeya

0 Votes 0 ·