从s3存储桶还原到sql服务器时出现错误数据库备份/还原选项未启用 [英] restore from s3 bucket to sql server getting error Database backup/restore option is not enabled

问题描述

当我尝试从s3存储桶中还原时出现这种错误

I got this kind of error when I tried to restore from s3 bucket

-错误消息

消息50000，级别16，状态0，过程msdb.dbo.rds_restore_database，第49行[批处理开始第0行]

Msg 50000, Level 16, State 0, Procedure msdb.dbo.rds_restore_database, Line 49 [Batch Start Line 0]

数据库备份/还原选项不是已启用或正在启用中.请再试一次之后.用法:执行msdb.dbo.rds_restore_database @restore_db_name，@ S3_arn_to_restore_from，[@ KMS_master_key_arn] @restore_db_name:名称正在还原的数据库的数量.@ S3_arn_to_restore_from:的S3 ARN用于从中还原数据库的备份文件.@KMS_master_key_arn:KMS客户主密钥ARN用来解密备份文件.

Database backup/restore option is not enabled yet or is in the process of being enabled. Please try again later. USAGE: EXECUTE msdb.dbo.rds_restore_database @restore_db_name, @S3_arn_to_restore_from, [@KMS_master_key_arn] @restore_db_name : Name of the database being restored. @S3_arn_to_restore_from : S3 ARN of the backup file used to restore database from. @KMS_master_key_arn : KMS customer master key ARN to decrypt the backup file with.

-执行的代码

exec msdb.dbo.rds_restore_database 
@restore_db_name='C2', 
@s3_arn_to_restore_from='arn:aws:s3:::slkk/31_May_2019_C2.bak'; 

请帮助我.我正在使用aws免费帐户.如何启用备份还原?

Please help me. I am using aws free account. How do I enable backup restore?

推荐答案

转到IAM并按以下步骤创建具有权限的新角色:

Go to IAM and crete new Role with Permissions as follow:

• AWSBackupServiceRolePolicyForRestores
• AWSBackupServiceRolePolicyForBackup

转到RDS>选项组*创建组(名称:SqlServerBackupRestore，描述:xxx，引擎:选择数据库引擎，主引擎版本:选择数据库实例的版本.*点击创建

Go to RDS > Option groups * Create group (Name: SqlServerBackupRestore, Description: xxx, Engine: Select your DB engine, Major Engine Version: Select version of your DB instance. * Click Create

创建组后，单击创建的组的名称以进行编辑.*单击添加选项*选择选项:SQLSERVER_BACKUP_RESTORE*选择您在先前步骤中创建的IAM角色*选择立即以安排即时更改

Once grup is created, click the name of created group to Edit. * Click Add option * Select option: SQLSERVER_BACKUP_RESTORE * Select IAM role you created in previous steps * Select Immediately to schedule instant change

返回RDS>数据库并选择您的实例*单击修改*选择您在上一步中创建的选项组

Back to RDS > Databases and select your instance * Click Modify * Select Option group you created in previous step

• 单击下一步
• 选择立即应用(不应该导致服务停机)

• 通过单击修改数据库实例"来应用更改
• 如果您已从SQL Management Studio连接到数据库，请关闭并再次连接.

这篇关于从s3存储桶还原到sql服务器时出现错误数据库备份/还原选项未启用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！