通过备份文件还原数据库

restore database [DATA/MEXICO-ALTAN-MEXICOCITY-201707-0001] from disk='E:\02部署资料\DB\DATA.bak' with replace, move 'DT' to 'E:\DB\Mexico700M\DATA.mdf', move 'DT_log' to 'E:\DB\Mexico700M\DATA_log.ldf'
restore database [PRO/MEXICO-ALTAN-MEXICOCITY-201707-0001/ProConfig] from disk='E:\02部署资料\DB\PRO.bak' with replace, move 'ProConfigDB' to 'E:\DB\Mexico700M\PRO.mdf', move 'ProConfigDB_log' to 'E:\DB\Mexico700M\PRO_log.ldf'

转载于:https://www.cnblogs.com/huanglong1987/p/7574320.html