53. sql2005“备份集中的数据库备份与现有的xx数据库不同”解决方法

RESTORE DATABASE LiveBOS_KeJi
FROM DISK = 'D:LiveBOS_KeJi_backup_201503090000.bak' --bak文件路径
with replace,
MOVE 'LiveBOS_KeJi' TO 'F:document_pathsqlserver2005LiveBOS_KeJi.mdf', --mdf文件路径
MOVE 'LiveBOS_KeJi_log' TO 'F:document_pathsqlserver2005LiveBOS_KeJi.ldf' --ldf文件路径

原文地址:https://www.cnblogs.com/zkx4213/p/4324529.html