restore test1 database into test2 database

Question

User-1061947019 posted

Database back up and restore is easy when the database has same name. 

I am trying to restore test1 database into test2 database. I am not able to restore it, reason should be test1_log and test1_data can not be changed to test2_log and test2_data. Anybody can help?

Answer 1

User-332238837 posted

I presume you are using SQL Server Dev, if so then back your database up and the restore it over the database you want to overwrite

Answer 2

User-1061947019 posted

When i restore tes1 database into test2 database, test2 dB creating test1.log and test1.data but not test2.log and test2.data.