如何在Amazon RDS上从SQL Server导出/备份数据库

截至7月,这可以通过以下方式实现:

在RDS仪表板下,使用"SQLSERVER_BACKUP_RESTORE"选项创建一个新选项组.

更新RDS实例以使用新创建的选项.

打开SQL Management Studio,连接到RDS数据库并执行以下操作以启动备份:

USE [msdb]
GO

DECLARE   @return_value int

EXEC  @return_value = [dbo].[rds_backup_database]
      @source_db_name = 'your_database_name',
      @S3_arn_to_backup_to = 'arn:aws:s3:::your-bucket-name/folder/db.bak',
      @KMS_master_key_arn = NULL,
      @overwrite_S3_backup_file = NULL

SELECT    'Return Value' = @return_value

GO

要检查备份的进度,请运行以下命令:

> USE [msdb] GO
> 
> DECLARE   @return_value int
> 
> EXEC  @return_value = [dbo].[rds_task_status]         @db_name =
> 'your_database_name',         @task_id = <<<found in result of previous query>>>
> 
> SELECT    'Return Value' = @return_value
> 
> GO

更多信息请访问:https://aws.amazon.com/blogs/aws/amazon-rds-for-sql-server-support-for-native-backuprestore-to-amazon-s3/