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.