Click here to Skip to main content
15,886,873 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
@s3_arn_to_backup_to='arn:aws:s3:::bucket_name/tempfolderpath/file_name_and_extension',

if can create tempfolderpath everytime on S3 (tempfolderpath name is the date run the backup )by query.

What I have tried:

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',
@kms_master_key_arn='arn:aws:kms:region:account-id:key/key-id',
@overwrite_S3_backup_file=1;
Posted
Updated 4-May-22 5:38am
v2
Comments
Maciej Los 10-Apr-22 5:07am    
What version of MS SQL server?
SELECT @@version;
Silver Lu 10-Apr-22 23:29pm    
MS SQL Server 2019 - Standard edition (64 - bit)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900