Skip to content

Instantly share code, notes, and snippets.

@peleteiro
Created October 16, 2023 13:07
Show Gist options
  • Save peleteiro/2971a6f1fa67cce498bd105c6bdb3c93 to your computer and use it in GitHub Desktop.
Save peleteiro/2971a6f1fa67cce498bd105c6bdb3c93 to your computer and use it in GitHub Desktop.
Backup do MS-SQL na RDS
declare @backup_to nvarchar(1000)
set @backup_to = 'arn:aws:s3:::evorafarma-backup/medicator/medicator-mssql-' + FORMAT(CURRENT_TIMESTAMP, 'yyyyMMddHHmmss') + '.bak'
exec msdb.dbo.rds_backup_database
@source_db_name='MEDICATOR',
@s3_arn_to_backup_to=@backup_to,
@overwrite_s3_backup_file=1,
@type='FULL';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment