sql server - Restore database backup from a different database name

最新推荐文章于 2024-06-25 12:15:36 发布

xylz_yang

最新推荐文章于 2024-06-25 12:15:36 发布

阅读量446

点赞数

本文链接：https://blog.csdn.net/xylz_yang/article/details/68489102

版权

situation: DB1, DB2( not exists)

1. create backup of DB1, db1.bak

2. restore to DB2 with db1.bak

1) list the logic name of backup

RESTORE FILELISTONLY FROM DISK='D:\db1.bak'

2) resotre

      RESTORE DATABASE DB2 FROM DISK='D:\db1.bak'
      WITH
       MOVE 'LogicName4DB1MDF' TO 'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Data\DB2.mdf',
       MOVE 'LogicName4DB1LDF' TO 'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Data\DB2_log.ldf'