sql-server - 在同一 Amazon RDS 上创建重复的 SQL Server 数据库

Question

背景:我正在将一些客户端迁移到 AWS RDS SQL 服务器实例。每个数据库都有两个数据库:一个用于实时数据，另一个用于训练数据，这是其实时数据的副本。通过使用实时数据库定期恢复训练数据库，使其保持最新。理想情况下，这些数据库将托管在同一个 RDS 实例上，因为它们没有那么大，并且托管成本会减半。

问题:亚马逊有这些限制 in their documentation :

You can't restore a backup file to the same DB instance that was used to create the backup file. Instead, restore the backup file to a new DB instance. Renaming the database is not a workaround for this limitation.

You can't restore the same backup file to a DB instance multiple times. That is, you can't restore a backup file to a DB instance that already contains the database that you are restoring. Renaming the database is not a workaround for this limitation.

因此，像往常一样备份实时数据库并将其恢复到训练数据库是不可能的。除了为每个客户端托管两个单独的实例之外，我最好的选择是什么？

Answer 1

好消息:

前面 the RDS Documentation 中列出的限制已被删除:

You can't restore a backup file to the same DB instance that was used to create the backup file. Instead, restore the backup file to a new DB instance. Renaming the database is not a workaround for this limitation.

You can't restore the same backup file to a DB instance multiple times. That is, you can't restore a backup file to a DB instance that already contains the database that you are restoring. Renaming the database is not a workaround for this limitation.

我刚刚对此进行了测试，并且能够使用 msdb.dbo.rds_restore_database 存储过程将同一备份多次恢复到同一 RDS SQL Server 上的不同数据库名称，没有出现任何问题在链接文档中定义。