Create a copy of a database in SQL Server 2008 R2

Question

I am using SQL Server 2008 R2 Edition and I have a database dbCRM with many tables and other database objects.

Now I created a database dbCRMTest and I want to copy all the database objects from the first database dbCRM to second dbCRMTest.

How do we achieve this?

And at no point in your searching, did you come across DTS packages? — Moo-Juice, Nov 12 '13 at 09:20
Here you go: http://stackoverflow.com/questions/12704572/create-duplicate-sql-database-for-testing — Sunny Sharma, Nov 12 '13 at 09:23
Possible duplicate of [How to copy SQL Server 2008 R2 database from one machine to another](https://stackoverflow.com/questions/18866321/how-to-copy-sql-server-2008-r2-database-from-one-machine-to-another) — CodeMonkey123, Oct 26 '17 at 10:12

score 2 · Answer 1 · answered Nov 12 '13 at 09:22

2

1) Backup dbCRM

2) Restore dbCRM backup to dbCRMTest with overwrite

answered Nov 12 '13 at 09:22

Sully

1 Answers1