Database restore without deleting old database

Question

I've done a copy of my database, using SQL Server 2008 R2 (DB -> Tasks -> Back Up).
Now I'm trying to restore it (DB -> Tasks -> Restore DataBase).

But SQL Studio give me an error and say, that I need to delete old DB to do it. How to restore it without deleting?

Please tick mark on option - Overwrite the existing database (With Replace) in "Restore option" while you restore your database. — Krishnraj
– Krishnraj, Commented Jan 24, 2014 at 8:55

robnick · Accepted Answer · 2014-01-24 09:04:06Z

I'm assuming you want a second copy of your DB, but with another name... since you want to "restore it without deleting"? You can definitely do this.

Instead of selecting your current DB, right click on the "Database" item in the object explorer window
In the context popup window select "Restore Database...".
In the window that pops up, enter in a 'To Database' name for your copied DB, i.e. the new name for the DB copy. So if your original was TradeWind, call this one TradeWindCopy for example.
Make sure the 'From database' radio button is selected, and in the dropdown select the backup you just made (tick the required check box). You could also restore 'from device' if you wanted - in that case you need to select a ".bak" file to restore from.
Click the OK button and your DB backup is now restored as the new DB with the name you set in step 3.

Good luck.

Community · Accepted Answer · 2017-05-23 12:40:37Z

2

there's an option called "Overwrite the existing database" click on it and it will work.
By renaming the old / new database you can achieve that. ( probably not want u want )

Here's an explanation from MSDN

CommunityBot

1

answered Jan 24, 2014 at 8:55

dan

1212 bronze badges

Danson Mwangi · Accepted Answer · 2014-01-24 14:24:14Z

0

You can Simply use a script to achieve that,

    RESTORE DATABASE newdbname FROM disk='database location on drive'

This will restore you database with a new name without tampering with your current databases on the server.

answered Jan 24, 2014 at 14:24

Danson Mwangi

11 bronze badge

3 Answers 3