Q: How do I copy a database in SQL Server 2000? How do I create a new database that is an exact copy of an existing one in SQL Server 2000?
For example, I have an existing database DB1. I wish to create a new database named DB2 that is the exact copy of the old database DB1.
How can I achieve this?

A: *

*Backup the database DB1. 

*Create a new database DB2 

*Restore the backup of database DB1 in the new database DB2

