--1,列出源文件的逻辑名和物理名
RESTORE FILELISTONLY
FROM DISK = 'F:\TempShare\MoveManager\IntegralWeb_db_200612070304.BAK' --备份文件的路径
/*
Result:
LogicalName PhysicalName Type FileGroupName Size MaxSize
IntegralAccountingSQL_dat C:\Data2\integralweb.mdf D PRIMARY 229376000 35184372080640
IntegralAccountingSQL_log C:\Data2\integralweb_log.ldf L NULL 516096 35184372080640
*/
--2, 恢复数据库, Move后的文件名必须是逻辑名, TO后的路径为此数据库存放的路径和名字(名字自定义)
RESTORE DATABASE IntegralWeb
FROM DISK = 'F:\TempShare\MoveManager\IntegralWeb_db_200612070304.BAK' --备份文件的路径
WITH MOVE 'IntegralAccountingSQL_dat' TO 'E:\Microsoft SQL Server\MSSQL\Data\IntegralWeb.mdf',
MOVE 'IntegralAccountingSQL_log' TO 'E:\Microsoft SQL Server\MSSQL\Data\IntegralWeb.ldf'