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
– Moo-Juice, Commented Nov 12, 2013 at 9:20
Possible duplicate of How to copy SQL Server 2008 R2 database from one machine to another — CodeMonkey123
– CodeMonkey123, Commented Oct 26, 2017 at 10:12

Sully · Accepted Answer · 2013-11-12 09:22:02Z

2

1) Backup dbCRM

2) Restore dbCRM backup to dbCRMTest with overwrite

answered Nov 12, 2013 at 9:22

Sully

15k5 gold badges56 silver badges83 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1