-
Couldn't load subscription status.
- Fork 822
Open
Description
It wold be important the support of tags directly upload on AWS S3 Storage.
For example:
-- Set the S3 URL for backups
SET @URLs = 's3://my-s3-bucket.region.amazonaws.com';
-- Execute the DatabaseBackup stored procedure with specified parameters
EXECUTE master.dbo.DatabaseBackup
@Databases = @DB,
@URL = @URLs,
@DirectoryStructure = @DirectoryStructures,
@FileName = @FileNames,
@BackupType = 'FULL',
@MAXTRANSFERSIZE = 15728640,
@NumberOfFiles = 1,
@LogToTable = 'Y';
@Tags = '{{"Key01": "Value01"}, {"Key02": "Value02"}}'
It's would make possible various scenarious for future automations on AWS S3.
In my situation, structure of folder on AWS S3 follow the next tree:
- s3bucket/
- sqlbackups/
- databaseName/
- DIFF/
- databaseName_DIFF_date.bak
- FULL/
- databaseName_FULL_date.bak
This implementation would make possible Tags Filter in S3 Lifecycle Policies.
Today, in S3 Lifecycle Policies don't possible use of wild cards, with '*/DIFF/' or '*/FULL/' for filter dynamic folder or archive names in backup structure.
Therefore adding Tags suport directly in AWS S3 upload would simplify many possibilities for automations and most more.
It's possible make this?
Metadata
Metadata
Assignees
Labels
No labels