还原数据库时出错 [英] Error while restoring the database

问题描述

我正在使用此查询来还原数据库.

I''m using this query to restore the database.

RESTORE DATABASE yy
FROM DISK = 'E:\dddd\db\db.bak'
WITH MOVE 'Final_Data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL\DATA\yy.mdf',
MOVE 'Final_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL\DATA\yy_1.ldf', recovery

但这给我一个错误"The file on device ''E:\dddd\db\db.bak'' is not a valid Microsoft Tape Format backup set."

But this give me an error "The file on device ''E:\dddd\db\db.bak'' is not a valid Microsoft Tape Format backup set."

推荐答案

http://support.microsoft.com/kb/905616 [^ ]

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