sql-server - 将 .bak mssql 2005 恢复到新的 mssql 2008r2 服务器

Question

我从服务器 A 创建了一个具有以下规范的 .bak 文件(备份):Windows Server 2003、MSSQL 2005。现在我想在具有以下规范的新服务器 B 上恢复此备份:Windows 8、MSSQL 2008 年 R2。我做了以下尝试进行恢复

1. Copy files to the new server(Server B)
2. Clicked on Microsoft SQL Server Management Studio 2008R2(Server B)
3. Right click on Databases to create a new Database called Boom (Server B)
4. After creating the new Database(Boom), right clicked on Tasks->Restore->Database and
5. On the source for restore area, Clicked From device and located the .bak file, select it and cliked ok.

我没有收到成功消息，而是收到以下错误:

Restore failed for Server 'Server B'.(Microsft.SqlServer.SmoExtended) Additional information: System.Data.SqlError: The backup set holds a backup of a database other than the existing 'Boom' database(Microsoft.SqlServer.Smo).

请协助，我是 MSSQL 的新手

Answer 1

Right click on Databases to create a new Database called Boom (Server B)

After creating the new Database(Boom), right clicked on Tasks->Restore->Database and

好吧，现在您正在创建一个新数据库并尝试用另一个数据库的备份覆盖它。因此:

The backup set holds a backup of a database other than the existing 'Boom' database

WITH REPLACE 选项允许您继续，但只是避免间接开始:恢复数据库，不要创建新数据库。

您可能需要先删除您创建的冗余 Boom 数据库。如果出于某种原因无法删除数据库，则必须使用 WITH REPLACE。