RDS服务器备份

Question

目的是导出RDS并将数据加载到本地mssql DB。

尝试备份rds服务器时出现以下错误。

用于初始化的SQL语句：

USE [msdb]
GO
DECLARE   @return_value int
EXEC  @return_value = [dbo].[rds_backup_database]
      @source_db_name = 'abcd',
      @S3_arn_to_backup_to = 'arn:aws:s3:::abcd/test_09_May.bak',
      @KMS_master_key_arn = NULL,
      @overwrite_S3_backup_file = NULL
SELECT    'Return Value' = @return_value
GO

查询查看状态：

exec msdb.dbo.rds_task_status
EXEC msdb.dbo.rds_task_status 
    @db_name = 'abcd', -- sysname
    @task_id = 7 -- int
exec msdb.dbo.rds_task_status @task_id = 7
exec msdb.dbo.rds_task_status @db_name='abcd'

失败原因- taskinfo列：

1. Aborted the task because of a task failure or an overlap with your preferred backup window for RDS automated backup.
A WebException with status ConnectFailure was thrown.

2. Aborted the task because of a task failure or an overlap with your preferred backup window for RDS automated backup.
Access Denied

Answer 1

这两个问题都与S3存储桶有关：

对于第一个问题，您要备份的s3存储桶与您的RDS实例不在同一区域。

对于第二个问题，选项组中使用的角色没有相应存储桶的权限。转到Security Credentials -> Roles ->，选择策略，然后编辑。

Answer 2

我建议您改用DB导出，RDS不允许在AWS环境之外导出。

Answer 3

在我的存储桶中添加S3策略为我解决了问题

{
    "Version": "2012-10-17",
    "Id": "123",
    "Statement": [
        {
            "Sid": "",
            "Effect": "Allow",
            "Principal": "*",
            "Action": "s3:*",
            "Resource": "arn:aws:s3:::mybucket/*"
        }
    ]
}