aws-rds

It’s possible to compress mssql backups in rds by turning compression on/off via rdsadmin commands;

        
bash
        

            
        
     
exec rdsadmin..rds_set_configuration 'S3 backup compression', 'true'; 
exec rdsadmin..rds_set_configuration 'S3 backup compression', 'false'; 

Note that it’s possible to do this when the server instance is sqlexpress, however in that case when actually performing the backup it will fail due to sqlexpress not supporting compressed backups.

Backup

        
perl
        

            
        
     
exec msdb.dbo.rds_backup_database 
        @source_db_name='database_name', 
        @s3_arn_to_backup_to='arn:aws:s3:::bucket_name/file_name_and_extension',
        @overwrite_S3_backup_file=1,
        @type='differential';

Restore

        
perl
        

            
        
     
exec msdb.dbo.rds_restore_database 
        @restore_db_name='database_name', 
        @s3_arn_to_restore_from='arn:aws:s3:::bucket_name/file_name_and_extension';

Status

        
perl
        

            
        
     
exec msdb.dbo.rds_task_status @db_name='database_name';

Cancel

        
perl
        

            
        
     
exec msdb.dbo.rds_cancel_task @task_id=1234;

More information#

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.html