Created
October 16, 2023 13:07
-
-
Save peleteiro/2971a6f1fa67cce498bd105c6bdb3c93 to your computer and use it in GitHub Desktop.
Backup do MS-SQL na RDS
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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