make a copy of database

[tuzojazz]

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?

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.

 

[ptheriault]

make a backup of your database and follow the steps from this thread.

thread183-1300973

- Paul
- Database performance looks fine, it must be the Network!