sql-server - 从 SSMS 中的备份还原数据库 - Amazon RDS SQL Server 错误 229

Question

我刚刚注册了 Amazon Web Services 以托管我的 ASP.NET MVC 5 应用程序。我的应用程序使用 3 个数据库，1 个来自数据库优先方法，2 个来自代码优先方法。为此，我通过连接到 RDS 的给定服务器名称以及主用户名和密码，从 SSMS 创建了数据库。但现在我想从本地计算机恢复我的数据库第一个数据库。当我尝试这样做时，当我按下从设备添加备份时发生以下错误:

我尝试在该数据库属性中授予EXECUTE 权限，但没有用。我怎样才能恢复它？

Answer 1

使用RDS将数据传输到RDS时，无法使用备份和恢复。您需要使用其他方法来获取其中的数据。

If you have an existing Microsoft SQL Server deployment that you want to move to Amazon RDS, the complexity of your task depends on the size of your database and the types of database objects that you are transferring. For example, a database that contains data sets on the order of gigabytes, along with stored procedures and triggers, is going to be more complicated than a simple database with only a few megabytes of test data and no triggers or stored procedures.

RDS for SQL Server service does not currently support RESTORE DATABASE ... FROM FILE, because the database and log file backups must be local to the SQL Server instance. Similarly, FILESTREAM is also not supported at this time.

The BULK INSERT and OPENROWSET(BULK...) statements from the server are not supported import procedures due to their dependency on the ADMINISTER BULK OPERATIONS permission which is not granted for SQL Server DB instances. Please use the process outlined below to import data to a SQL Server DB instance.

http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.html