Restore SQL Server database in same SQL server with different name

Description : 

I have an existing database called ABC, and I have a  DB backup  file (ABC_20140206.bak)  of ABC a few months back.

Now, I need to restore the backup file to same SQL server for some data comparison.


How to restore the database without overwriting the existing one?

http://stackoverflow.com/questions/5228597/restore-sql-server-database-in-same-pc-with-different-name

http://stackoverflow.com/questions/6267273/how-to-restore-to-a-different-database-in-sql-server?lq=1


Steps to do : 

1.In SQL Server Management Studio, right click the existing database and Rename  ABC to ABC_Orig (to avoid overwriting)

(Without renaming the database, the existing database will be impacted although the new restoration is successful )

2.Then in SQL Server Management Studio, to restore the backup file, by allocating new database file name 



3.Once restoration is successful, change back the rename  the database name ABC_Orig back to ABC.



评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值