Please provide windows powershell commands to import a database backup file which is on azure blob storage account to my azure SQL vm in which sql image is installed

Question

Please provide windows powershell commands to import a database backup file which is on azure blob storage account to my azure SQL vm in which sql image is installed

Aravapalli Ojeswi 0

we have a windows sql vm where we have a preinstalled sql windows 2022 image in it. Now there is a database backup file that is stored in azure blob storage now we want to import that file into this azure sql vm
can we get any powershell commands for this?

Aravapalli Ojeswi 0 Reputation points

2024-11-04T12:05:52.3966667+00:00

@Olaf Helper so we are trying to automate the process of importing data from blob storage to Azure sql vm in that context we need powershell commands
SSingh-MSFT 16,371 Reputation points Moderator

2024-11-06T12:27:55.2333333+00:00

Hi Aravapalli Ojeswi,

Just checking if the provided suggested helped or you are still unable to proceed.

Thanks

2 answers

Your answer

Aravapalli Ojeswi 0 Reputation points

2024-11-04T12:05:52.3966667+00:00

@Olaf Helper so we are trying to automate the process of importing data from blob storage to Azure sql vm in that context we need powershell commands
SSingh-MSFT 16,371 Reputation points Moderator

2024-11-06T12:27:55.2333333+00:00

Hi Aravapalli Ojeswi,

Just checking if the provided suggested helped or you are still unable to proceed.

Thanks

Answer 1

Olaf Helper 47,436

Why a PowerShell script? You can use plan T-SQL to backup to / restore from Azure BLOB Storage, see

https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/sql-server-backup-and-restore-with-microsoft-azure-blob-storage-service?view=sql-server-ver16

Aravapalli Ojeswi 0 Reputation points

2024-11-04T12:24:07.8933333+00:00

hi @Olaf Helper we are automting the entire process of importing backup file into azure sql vm from azure blob storage account so in this perspective we require powershell commands

Answer 2

SSingh-MSFT 16,371 Moderator

Hi Aravapalli Ojeswi,

Welcome to Microsoft Q&A forum.

As I understand, you want to perform import the backup to Azure SQL VM.

You may do this using Backup job.

Please refer to https://learn.microsoft.com/en-us/azure/backup/backup-azure-sql-automation

for complete detailed documentation.

Also refer https://gist.github.com/voxon2/be29a3fd6dabbb9155ca to ExportAzureDatabaseToBlobStorage as reference and modify it as per you usecase.

Let us know if you have more queries.

Thanks

Share via

Please provide windows powershell commands to import a database backup file which is on azure blob storage account to my azure SQL vm in which sql image is installed

2 answers

Your answer