Migrate SQL Server 2014 Managed Backup Settings to SQL Server 2016

APPLIES TO: yesSQL Server noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

This topic covers migration considerations for SQL Server Managed Backup to Microsoft Azure when upgrading from SQL Server 2014 (12.x) to SQL Server 2016 (13.x).

The procedures and underlying behavior of SQL Server Managed Backup to Microsoft Azure has changed in SQL Server 2016 (13.x). The following sections describe the functional changes and their implications.

Overview

The following table describes some of the key functional differences for SQL Server Managed Backup to Microsoft Azure between SQL Server 2014 (12.x) and SQL Server 2016 (13.x).

Area SQL Server 2014 (12.x) SQL Server 2016 (13.x)
Namespace: smart_admin managed_backup
System Stored Procedures: sp_set_db_backup

sp_set_instance_backup
managed_backup.sp_backup_config_basic (Transact-SQL)

sp_backup_config_advanced

sp_backup_config_schedule
Security: SQL credential using a Microsoft Azure storage account and access key. SQL credential using a Microsoft Azure Shared Access Signature (SAS) token.
Underlying Storage: Microsoft Azure Storage using page blobs. Microsoft Azure Storage using block blobs.

Benefits

There are several benefits to using the new functionality in SQL Server 2016 (13.x).

  • Block blobs cost less to store.

  • With striping, you can store much larger backups (12 TB versus 1 TB for page blobs).

  • Striping also improves the restore time for large databases

  • For other improvements to SQL Server Managed Backup to Microsoft Azure in SQL Server 2016 (13.x), see SQL Server Managed Backup to Microsoft Azure.

Considerations

After you upgrade from SQL Server 2014 (12.x), note the following SQL Server Managed Backup to Microsoft Azure considerations:

  • Any databases previously configured for SQL Server Managed Backup to Microsoft Azure on SQL Server 2014 (12.x) will continue to use the smart_admin system procedures and underlying behavior on SQL Server 2016 (13.x).

  • The smart_admin procedures are not supported for any new configurations of SQL Server Managed Backup to Microsoft Azure on SQL Server 2016 (13.x). You must use the new managed_backup procedures and functionality.

See Also

SQL Server Managed Backup to Microsoft Azure