例:
RESTORE DATABASE temp1 FROM DISK = N'C:\temp.bak' WITH FILE=1,NOUNLOAD,STATS=10,RECOVERY,REPLACE,
MOVE N'temp_data' TO N'c:\temp1_data.mdf',
MOVE N'temp_log' TO N'c:\temp1_log.ldf'
RESTORE DATABASE temp1 FROM DISK = N'C:\temp.bak' WITH FILE=1,NOUNLOAD,STATS=10,RECOVERY,REPLACE,
MOVE N'temp_data' TO N'c:\temp1_data.mdf',
MOVE N'temp_log' TO N'c:\temp1_log.ldf'
手工操作要在选择备份文件后在"选项"中改变.MDF和.LDF的名字就可以了
select master..filename from sysfiles