Copy Azure premium storage to standard storage for redundancy

azure

For our SQL servers we run backups onto a shared premium storage disk. Premium storage is locally redundant and I would like to copy these backups to a standard storage disk in order to take advantage of it's Geo-redundancy. What is the best way to do this?

Best Answer

The only way that I'm aware of would be to just start copying, robocopy is likely the most efficient method.

However, if you are aware writing backups to local disk uses up your alloted IOPS. It is best practice, and recommended by Microsoft, to use the backup to URL for database backups. Doing this does not count against your IOPS for the disk or VM.

Related Solutions

Sql-server – copy backup from azure blob

You can use AZCopy to move files from blob to Filesystems or eitherwise..

Below is the syntax..

AzCopy 
/Source:https://myaccount.blob.core.windows.net/mycontainer 
/Dest:C:\myfolder 
/SourceKey:key 
/Pattern:a 
/S

use the pattern option to specify name (this will work like SQL like query)

From SQLServer 2014,you can also restore from Blob directly..

Restoring From Backups Stored in Microsoft Azure

Sql-server – SQL Server Diff not restoring from Azure BLOB storage

Most likely, you have multiple Differential backups in your DB_NAME_DIFF.bak file, and the restore is picking one that occurred before the most recent FULL. As I hinted in my comment, and Scott stated in his.

Edit the following to check for multiple files in a backup device:

RESTORE HEADERONLY   
FROM DISK = N'C:\AdventureWorks-FullBackup.bak'   
WITH NOUNLOAD;  
GO

Best Answer

Related Solutions

Sql-server – copy backup from azure blob

Sql-server – SQL Server Diff not restoring from Azure BLOB storage

Related Question