MSSQL Server数据库还原错误 [英] MSSQL Server Database restore error

问题描述

我正在尝试从在SQL SERVER 2000上创建的数据库备份中还原MSSQL 2005上的数据库.

在SQL Server 2005服务器上，数据库兼容性级别设置为(80).

我正在尝试运行以下命令进行恢复，

I am trying to restore a database on MSSQL 2005 from backup of database which is created on SQL SERVER 2000.

On SQL server 2005 server , database compatibility level set to (80).

I am trying to run following for restore,

ALTER DATABASE IWT
SET SINGLE_USER WITH
ROLLBACK IMMEDIATE
RESTORE DATABASE IWT
FROM DISK = 'C:\IWT.bak'
WITH MOVE 'IWT_Data' TO 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\RAR_Data.mdf',
MOVE 'IWT_Log' TO 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\RAR_log.ldf',
REPLACE

ALTER DATABASE IWT SET MULTI_USER
GO

但出现错误，

but getting error as,

Msg 3201, Level 16, State 2, Line 4
Cannot open backup device 'C:\IWT.bak'. Operating system error 2(error not found).
Msg 3013, Level 16, State 1, Line 4
RESTORE DATABASE is terminating abnormally.

我尝试了所有在线可用资源，但没有运气.

I have tried all resources available online but no luck.

推荐答案

阅读有关如何使用google的文章.我搜索了错误消息，发现 ^ ].

糟糕，答案在那里，但在注释中，实际答案是

Read my article on how to use google. I googled the error message and found this[^].

Oops, the answer is there, but in the comments, the actual answer is here[^].

这篇关于MSSQL Server数据库还原错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！