SQL命令行还原Bak文件

2019独角兽企业重金招聘Python工程师标准>>>

查看数据库的逻辑名称

restore filelistonly from disk = 'D:\dbbak\init\icore.bak'；

还原Bak文件

restore database icoreDB from disk = 'D:\dbbak\init\icore.bak' with move 'icoreDB' to 'D:\dbdata\icore_init.mdf', move 'icoreDB_log' to 'D:\dbdata\icore_init_log.LDF';

附加 MDF 文件

exec sp_attach_db 'icoreDB','D:\dbdata\icore_init.mdf','D:\dbdata\icore_init_log.ldf';

转载于:https://my.oschina.net/billyteam/blog/911829