• Can I query the region from within the SQL Server itself?
Anything like rdsadmin.dbo.rds_show_configuration that include instance specs?
I have an SP that is clearing all backup tables from production to a secondary DB.
I want to back it up to S3 and drop those tables.
I have the backup command ready:
declare @BackupCMD varchar(4000) = concat('exec msdb.dbo.rds_backup_database @source_db_name=''', 'BackupTables', ''', @s3_arn_to_backup_to=''arn:aws:s3:::', @bucket, '/', @file_name, '.bak''
, @kms_master_key_arn=''', @arn, '''')
The issue is we have instances over several regions and bucket and key need to match the same region as the instance.
If I can I will be able to cross it with the ARN / buckets list that need to match.
Thank you!
This is blocked by security team. Would work...