注意一下恢复时的源文件路径和恢复到的路径是否正确
RESTORE FILELISTONLY 命令可以帮助查看源文件路径
如
RESTORE FILELISTONLY
from disk='f:\tdmis.bak' 结果为
tdmis_Data e:\database\tdmis.mdf D PRIMARY 497221632 35184372080640
tdmis_Log e:\database\tdmis_log.ldf L NULL 1048576 35184372080640
然后用
restore database tdmis
from disk='f:\tdmis.bak'
with NORECOVERY,
move 'tdmis_Data' to 'e:\database\tdmis.mdf',
move 'tdmis_Log' to 'e:\database\tdmis_log.ldf'
就可以了