Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
|
| Priority | Major |
| Complexity | Unknown |
| Component | DB - SQL Server |
| Version | 18.0 |
Request to enhance our support of backup devices to include support for extract/scripting/GUI work with backup objects under the device.
|
|
217 KB
|
|
159 KB
After further analysis, I believe the request is to enhance the scripting of the generic DDL statements to include new syntax for the alter versions of sql server. I can do this quickly and will port code fixes back to version 17. We currently don't have extract/script/GUI support for backup files under the backup device. Also, I would note that our node is called "Backup". This should be renamed to Backup Devices
The following options have been added for SQL Server 2012+:
MIRROR TO <backup_device> [ ,...n ]
with options:
COPY_ONLY COMPRESSION | NO_COMPRESSION BUFFERCOUNT <buffercount> MAXTRANSFERSIZE <maxtransfersize> NO_CHECKSUM | CHECKSUM STOP_ON_ERROR | CONTINUE_AFTER_ERROR
ENCRYPTION (ALGORITHM = { AES_128 | AES_192 | AES_256 | TRIPLE_DES_3KEY } , { SERVER CERTIFICATE = <Encryptor_Name> | SERVER ASYMMETRIC KEY = <Encryptor_Name> } )
Also the following 2 options have been removed for SQL Server 2012+:
MEDIAPASSWORD = <mediapassword> PASSWORD = <password>
msdb.dbo.backupfile msdb.dbo.backupfilegroup msdb.dbo.backupmediafamily msdb.dbo.backupmediaset msdb.dbo.backupset
Link To Documentation: SQL Server Backup Database
Committed revision: 51709
P.S. Our current tree node does not display of backups that are not named.
The following options have been added for SQL Server 2012+:
MIRROR TO <backup_device> [ ,...n ]
with options:
COPY_ONLY COMPRESSION | NO_COMPRESSION BUFFERCOUNT <buffercount> MAXTRANSFERSIZE <maxtransfersize> NO_CHECKSUM | CHECKSUM STOP_ON_ERROR | CONTINUE_AFTER_ERROR
ENCRYPTION (ALGORITHM = { AES_128 | AES_192 | AES_256 | TRIPLE_DES_3KEY } , { SERVER CERTIFICATE = <Encryptor_Name> | SERVER ASYMMETRIC KEY = <Encryptor_Name> } )
Also the following 2 options have been removed for SQL Server 2012+:
MEDIAPASSWORD = <mediapassword> PASSWORD = <password>
msdb.dbo.backupfile msdb.dbo.backupfilegroup msdb.dbo.backupmediafamily msdb.dbo.backupmediaset msdb.dbo.backupset
Link To Documentation: SQL Server Backup Database
Committed revision: 51709
P.S. Our current tree node does not display of backups that are not named.
Verified in ADS-18.0.-RC-7 and ADS-17.0.10-10. Refer screenshots for SQL SERVER 2014 and 2016.'SQLSERVER2016 _Options.png' and 'SQLSERVER2014_options.png'
Verified in ADS-18.0.-RC-7 and ADS-17.0.10-10. Refer screenshots for SQL SERVER 2014 and 2016.'SQLSERVER2016 _Options.png' and 'SQLSERVER2014_options.png'
Issue #14793 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build v18.0.0-alpha-12, v17.0.10-3 |
| Time Estimate 20 hours |
After further analysis, I believe the request is to enhance the scripting of the generic DDL statements to include new syntax for the alter versions of sql server. I can do this quickly and will port code fixes back to version 17. We currently don't have extract/script/GUI support for backup files under the backup device. Also, I would note that our node is called "Backup". This should be renamed to Backup Devices