Restore Issue in SQL Server 2012


I have a database ( Testdb1) which I need to create a copy, so I went into management studio and ran the copy database wizard.  The copy db is called (Testdb2) and everything looks good.  Now there has been some new data on testdb1 which I want to add to testdb2, so I ran a full backup on testdb1 and then tried to restore it to testdb2.  in the restore window I selected the testdb1.bak and then pointed it to the testdb2 database.  In the files window I changed the files to testdb2 and In the options window I selected "replace".  I ran the restore, which was successful, but now my original db (testdb1) is in restore mode!  What did I do wrong??  I just wanted testdb1.bak to update testdb2, so I am not sure why testdb1 was affected all.  

Please help!


Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DBAduck - Ben MillerPrincipal ConsultantCommented:
Because you needed to specify a new name for the database. In the restore window it presupposes that you want to restore to the same name.

So your restore clobbered your existing testdb1.
When you do restore by default the target database is the one you restore from. It seems that you restored over your original, Testdb1, database.
Randy Knight, MCMPrincipal ConsultantCommented:
This is why I don't use the GUI to execute commands.  Use it to set everything up then hit the "Script" button and validate that the script is doing what you want to do, then execute it.  This will help you learn the SQL commands as well.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
bjenningsAuthor Commented:
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.