脚本示例如下:
RESTORE DATABASE [gvILMSTest]
--FILE = N'Midata', FILE = N'Milog'
FROM DISK = N'E:DATAVLMS DATA BAKgvILMS_backup_200708120000.bak'
WITH FILE = 1,
MOVE N'gvilms' TO N'E:gvILMSVLMSTest.MDF',
MOVE N'gvilms' TO N'E:gvILMSVLMSTest.LDF',
NOUNLOAD,REPLACE, STATS = 10
