将数据库文件恢复至指定路径

restore database wwww
from disk='E:\DBBACKUP\20070716_wwww2.bak'
WITH MOVE 'wwww2'       TO 'F:\SqlData\wwww1.mdf',  
          MOVE 'wwww2_log' TO 'F:\SqlData\wwww1_log.ldf' 

 

转载于:https://blog.51cto.com/sqlserver/34254