Forum Discussion

Copper Contributor

Sep 09, 2019

Solved

SQL backup authentication after Storage Account upgrade to V2

Hi, I have some doubts before upgrading Storage Accounts to V2. Will the SQL credentials and access remain untouched for the SQL managed backups in SQL 2016 - using SAS tokens and for SQL 2014 usi...

azure backup

Data + Storage

Bryan Haslip
Sep 09, 2019
I went and tried this within my Azure account and both the SAS string and the storage account keys remained the same. I verified within SQL that both still functioned with SQL managed backups. As for performance there is no difference but the access cost is higher on the cool tier of storage. Please see the following Microsoft Doc. Let me know if you have additional questions!

https://docs.microsoft.com/en-us/azure/storage/blobs/storage-blob-storage-tiers

tymb

Bryan Haslip

Iron Contributor

Sep 09, 2019

I went and tried this within my Azure account and both the SAS string and the storage account keys remained the same. I verified within SQL that both still functioned with SQL managed backups. As for performance there is no difference but the access cost is higher on the cool tier of storage. Please see the following Microsoft Doc. Let me know if you have additional questions!

https://docs.microsoft.com/en-us/azure/storage/blobs/storage-blob-storage-tiers

tymb