| title | Migrate managed backup settings |
|---|---|
| ms.custom | seo-lt-2019 |
| ms.date | 12/17/2019 |
| ms.prod | sql |
| ms.prod_service | backup-restore |
| ms.reviewer | |
| ms.technology | backup-restore |
| ms.topic | conceptual |
| ms.assetid | ae937ebb-24ff-4a33-be3c-8f85328dfc75 |
| author | MikeRayMSFT |
| ms.author | mikeray |
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md] This topic covers migration considerations for [!INCLUDEss_smartbackup] when upgrading from [!INCLUDEssSQL14] to [!INCLUDEssSQL15].
The procedures and underlying behavior of [!INCLUDEss_smartbackup] has changed in [!INCLUDEssSQL15]. The following sections describe the functional changes and their implications.
The following table describes some of the key functional differences for [!INCLUDEss_smartbackup] between [!INCLUDEssSQL14] and [!INCLUDEssSQL15].
| Area | [!INCLUDEssSQL14] | [!INCLUDEssSQL15] |
|---|---|---|
| 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. |
There are several benefits to using the new functionality in [!INCLUDEssSQL15].
-
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 [!INCLUDEss_smartbackup] in [!INCLUDEssSQL15], see SQL Server Managed Backup to Microsoft Azure.
After you upgrade from [!INCLUDEssSQL14], note the following [!INCLUDEss_smartbackup] considerations:
-
Any databases previously configured for [!INCLUDEss_smartbackup] on [!INCLUDEssSQL14] will continue to use the smart_admin system procedures and underlying behavior on [!INCLUDEssSQL15].
-
The smart_admin procedures are not supported for any new configurations of [!INCLUDEss_smartbackup] on [!INCLUDEssSQL15]. You must use the new managed_backup procedures and functionality.