如何通过查询恢复备份文件..？ [英] How to restore backup file by query..?

问题描述

RESTORE DATABASE z
   FROM DISK = 'E:\z.bck' ;

此查询给出错误..请告诉我..

this query gives error..please tell me..

推荐答案

备份文件名中的拼写错误

try-

Spelling mistake in backup file name
try-

RESTORE DATABASE z
   FROM DISK = 'E:\z.bak' ;

希望，它有帮助：）

Hope, it helps :)

首先验证您的备份文件路径。

它应该存在。

然后你写了错误的backfile扩展它应该.bak而不是.bck

纠正它然后tr y。

First verify your backup file path.
It should exists.
Then you have written wrong backfile extension it should ".bak" not ".bck"
Correct it and then try.

USE [master]
GO
ALTER DATABASE DatabaseName SET RECOVERY SIMPLE
GO
RESTORE DATABASE [DatabaseName] FROM DISK = 'c:\Your Path\Filename.bak' 

这篇关于如何通过查询恢复备份文件..？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！