sql - 将database.bak从本地机器恢复到服务器

Question

我正在尝试使用图表和外键将整个数据库恢复到服务器上现有数据库我想用新数据库替换它，我尝试了以下脚本但没有成功

drop database  DuxburyCaravans    
go
RESTORE DATABASE stonestore
  FROM DISK = 'C:\Program Files\Microsoft SQLServer\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\DuxburyCaravans.BAK'
  WITH MOVE 'DuxburyCaravans' TO 'D:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\DuxburyCaravans.mdf',
  MOVE 'DuxburyCaravans_log' TO 'D:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\DuxburyCaravans.LDF'

但它出现了错误:

Msg 3702, Level 16, State 3, Line 3
Cannot drop database "DuxburyCaravans" because it is currently in use.
Msg 3201, Level 16, State 2, Line 1
Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\DuxburyCaravans.BAK'. Operating system error 3(failed to retrieve text for this error. Reason: 15105).
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

Answer 1

RESTORE仅适用于实际的服务器机器 - 这是您自己的 PC，还是一台单独的机器？

如果是单独的机器:你不能 从本地硬盘将数据库恢复到远程服务器 - 您需要放置 *.bak文件到服务器可以访问的驱动器上 - 例如服务器自己的本地驱动器，或服务器具有映射(和访问)的网络驱动器。