make a copy of database

• Gabriel Garcia

  Newbie

  Points: 6

  More actions

  November 17, 2006 at 5:41 pm

  #173502

  Hi:

  I have installed sql server 2005 express and SQL Server Management Studio Express

  How can I generate a database from another copying the structure and data?

  For example I have a database named Customers, I need to make a copy of Customers named Customers2. Customers2 also will be attached to the same Database Engine Server where Customers is attached.

  How I Can do it?

  Thanks!

  P.S.

  I tryied to make a copy of mdf an ldf files from Windows Explorer and renamed these files but I could not attach to the same Database Engine Server because I got an error.

• Rich Hansell

  SSCrazy

  Points: 2396

  More actions

  November 18, 2006 at 7:35 am

  #672798

  there are a couple of ways.. you can use Mgmt Studio and in object explorer you can right click on the DB you wish to copy and then click "copy database" which will launch the copy database wizard.. or you can do a backup of the existing DB and then restore it to the source server with a new name... Hope this helps!