November 17, 2006 at 5:41 pm
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.
November 18, 2006 at 7:35 am
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!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply