通过界面操作,将MsSql 2000数据还原到MsSql 2005中,经常报log文件不对,没办法,只好用脚本。
这里记录一下,以便下次备用。
RESTORE
FILELISTONLY
FROM DISK = N ' D:ABC.BAK '
RESTORE DATABASE [ MyData ]
FROM DISK = N ' D:ABC.BAK '
WITH MOVE ' MyData_Data ' TO N ' D:MyData_data.mdf ' ,
MOVE ' MyData_Log ' TO N ' D:MyData_log.ldf ' ,
NOUNLOAD, REPLACE , STATS = 10
FROM DISK = N ' D:ABC.BAK '
RESTORE DATABASE [ MyData ]
FROM DISK = N ' D:ABC.BAK '
WITH MOVE ' MyData_Data ' TO N ' D:MyData_data.mdf ' ,
MOVE ' MyData_Log ' TO N ' D:MyData_log.ldf ' ,
NOUNLOAD, REPLACE , STATS = 10