日期:2014-05-16 浏览次数:20469 次
RESTORE DATABASE dev_1_2
FROM DISK = 'E:\Point.Module.Customer\2012-10-25.bak'
with replace,
MOVE 'dev_1_2' TO 'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\dev_1_2',
MOVE 'dev_1_2_log' TO 'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\dev_1_2.log'
注释:dev_1_2是你需要还原的数据库名称,2012-10-25.bak'是你需要还原的备份文件。