首先先点击数据库的“新建查询”:输入语句 RESTORE FILELISTONLY FROM DISK = 'H:\students_management_system.bak'(此为.bak文件名)查看它原来的逻辑文件名。接着输入下面语句就OK 了!!!
RESTORE FILELISTONLY FROM DISK = 'H:\students_management_system.bak'
RESTORE DATABASE WF
FROM DISK = 'H:\students_management_system.bak'
with replace,
MOVE 'students_management_system' TO 'C:\WF.mdf',
MOVE 'students_management_system_log' TO 'C:\WF_log.ldf'
注释:'students_management_system'、'students_management_system_log'此名称基于第一步操作的结果。