Restore SQL Server database in same SQL server with different name

来源:互联网 发布:python 打开文件夹 编辑:程序博客网 时间:2024/04/30 15:40

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.



0 0
原创粉丝点击