RESTORE FILELISTONLY
FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\MYSH00120141211.bak'
RESTORE DATABASE MYSH001Test
FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\MYSH00120141211.bak'
WITH MOVE 'MYSH001' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\MYSH001Test.mdf',
MOVE 'MYSH001_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\MYSH001Test.ldf'
步骤1 可以看到备份集里的LogicalName和PhysicalName
PhysicalName先不管,你记下LogicalName就好了
步骤2 'MYSH001','MYSH001_Log'就是步骤1查询出来的LogicName