如果不要Move 则很快出现错误: Server: Msg 5105, Level 16, State 2, Line 3 Device activation error. The physical file name 'F:\data\Test_Data.MDF' may be incorrect. Server: Msg 3156, Level 16, State 1, Line 3 File 'Test_Data' cannot be restored to 'F:\data\test_Data.MDF'. Use WITH MOVE to identify a valid location for the file.
第二个move前是否少了个逗号?
把SQL启动服务停止,然后在运行,再试一下备份
restore filelistonly from disk='f:\testbackup.bak' 先看看备份信息。
restore filelistonly from disk='f:\testbackup.bak' 先看看备份信息。
Server: Msg 5105, Level 16, State 2, Line 3
Device activation error. The physical file name 'F:\data\Test_Data.MDF' may be incorrect.
Server: Msg 3156, Level 16, State 1, Line 3
File 'Test_Data' cannot be restored to 'F:\data\test_Data.MDF'. Use WITH MOVE to identify a valid location for the file.
先看看备份信息。
先看看备份信息。