SQL Server 2005数据库恢复脚本示例

脚本示例如下:

RESTORE DATABASE [gvILMSTest]

--FILE = N'Midata', FILE = N'Milog'

FROM DISK = N'E:/DATA/VLMS DATA BAK/gvILMS_backup_200708120000.bak'

WITH FILE = 1,

MOVE N'gvilms' TO N'E:/gvILMS/VLMS/Test.MDF',

MOVE N'gvilms' TO N'E:/gvILMS/VLMS/Test.LDF',

NOUNLOAD,REPLACE, STATS = 10