命令行下从bak文件恢复sqlserver数据库方法

注：本文所示访问从SqlServer 2000 – 2014版都是通用的

参考：http://blog.sina.com.cn/s/blog_5cdf6f450102dwir.html

1.先使用restore filelistonly命令显示数据库的逻辑文件名和数据库名称

restore filelistonly from disk = 'E:BaiduYunDownloadshifenzheng.bak'

　　

命令行下从bak文件恢复sqlserver数据库方法-风君雪科技博客

2.进行恢复

restore database kaifang
from disk = 'E:BaiduYunDownloadshifenzheng.bak'
with move 'linshi' to 'D:Program FilesMicrosoft SQL ServerMSSQL12.MSSQLSERVERMSSQLDATAlinshi.mdf',
move 'linshi_log' to 'D:Program FilesMicrosoft SQL ServerMSSQL12.MSSQLSERVERMSSQLDATAlinshi_log.ldf'