Forum Discussion
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 using regular SA connection keys?
Is there any read/write speed difference between V1 and V2? I.e. between V1 Standard and V2 Standard - Cool.
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
1 Reply
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