注：本文所示訪問從SqlServer 2000 - 2014版都是通用的。
1、先使用restore filelistonly命令顯示數據庫的邏輯文件名和數據庫名稱：
restore filelistonly
from
disk =
'E:\BaiduYunDownload\shifenzheng.bak'
2、進行恢復：
restore
database
kaifang
with
move
'linshi'
to
'D:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\linshi.mdf'
,
'linshi_log'
'D:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\linshi_log.ldf'
400 186 1886
