Copy database to same server but with a different name

[JabbaTheNut]

I have a production database named "PRODUCTION_DATABASE" on "SERVER1". I would like to copy this database (and all its views, stored procedures, etc.) to the same server but under a different database name (i.e., "TEST_DATABASE" on "SERVER1&quot. This copy will be used for software development testing purposes.

What is the best way to do this?

P.S. I have SQL Server 2000 Enterprise Edition.

Game Over, Man!

 

[ecobb]

Make a backup of your database, then restore the backup. When you start to restore, the wizard will give you the option of "Restore As". Just type in the name for the new database. This will create an exact copy of your existing database, data and all.


Hope This Helps!

Ecobb
- I hate computers!

 

[JabbaTheNut]

Thank you

Game Over, Man!