无法打开备份设备'C：\ TEMP \ Demo.bak'。操作系统错误2（系统找不到指定的文件。）。 [英] Cannot open backup device 'C:\TEMP\Demo.bak'. Operating system error 2(The system cannot find the file specified.).

问题描述

我试过了：

 RESTORE DATABASE [DemoDB]   
     FROM DISK = 'C:\TEMP\Demo.bak'   
      WITH FILE=1,   
        NORECOVERY;  

并且：

RESTORE DATABASE [DemoDB]  
   FROM DISK = 'C:\TEMP\Demo.bak'   
   WITH RECOVERY,  
   MOVE 'Demo_Data' TO 'C:\TEMP\Database\Demo_Data',   
   MOVE 'Demo_Log' TO 'C:\TEMP\Database\Logs\Demo_Log.ldf';  
GO

我一直收到这个错误：

Msg 3201, Level 16, State 2, Line 15
Cannot open backup device 'C:\TEMP\Demo.bak'. Operating system error 2(The system cannot find the file specified.).
Msg 3013, Level 16, State 1, Line 15
RESTORE DATABASE is terminating abnormally.

NETWORK SERVICE和MSSQLSERVER用户可以访问C：\ Temp文件夹。

NETWORK SERVICE and MSSQLSERVER users do have access to C:\Temp folder.

推荐答案

运行以下查询，看看是否得到输出：

Run the following query and see if you get the output:

从DISK ='C：\ TEMP \ Demo.bak'恢复FILELISTEL WITH WITH FILE = 1

GO

这篇关于无法打开备份设备'C：\ TEMP \ Demo.bak'。操作系统错误2（系统找不到指定的文件。）。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！