是这样的,我在恢复数据库时,我想让客户选择路径,这样就需要用到move,如下:
RESTORE DATABASE [test02] FROM DISK = N'd:\sqldata\test01.bak' WITH replace,move 'test01_Data' to 'E:\sourcehf\test02_DATA.MDF',move 'test01_log' to 'E:\sourcehf\test02_LOG.LDF',FILE = 1, NOUNLOAD , STATS = 10 , RECOVERY REST
RESTORE DATABASE [test02] FROM DISK = N'd:\sqldata\test01.bak' WITH replace,move 'test01_Data' to 'E:\sourcehf\test02_DATA.MDF',move 'test01_log' to 'E:\sourcehf\test02_LOG.LDF',FILE = 1, NOUNLOAD , STATS = 10 , RECOVERY REST