Skip to content

Tag add in backup archive directly in AWS S3 Storage #959

@correalenon

Description

@correalenon

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

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions