当你直接还原备份文件失败时,可以试试下面的方法
RESTORE FILELISTONLY from disk='E:\网站\采集测试\YuHeTZ.bak'
GO
use master
RESTORE DATABASE [YuHeTZ] FROM DISK = N'E:\网站\采集测试\YuHeTZ.bak' WITH FILE = 1,
MOVE N'YuHeTZ' TO N'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\YuHeTZ.mdf',
MOVE N'YuHeTZ_log' TO N'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\YuHeTZ_log.ldf',
NOUNLOAD, REPLACE, STATS = 10
GO
/*[YuHeTZ] 数据库名称*/
/*E:\网站\采集测试\YuHeTZ.bak 是备份文件和路径*/
/*D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\YuHeTZ.mdf 还原数据库*/