copy database to same server with new name

[nikky]

I want to copy a production database on my sql2000 server and add it to the server under a new name, so I can use it for testing.

If I create a .BAK file, how do I add the backup in as a new database with a different name using Enterprise Manager ?

 

[Corran007]

you could create a new database with a different name and restore the old one on to it. make sure you choose force restore over existing database and change the log and datafile locations from the original database to the new database names/locations.

You can also use tsql to do it. look under RESTORE, RESTORE (described) in bol. tells you all about it with examples. good stuff to know.

 

[administratorx]

After backing up the database, you may also right click on 'Databases'and then select 'All tasks' and then restore database. Make sure to enter the name that you want the database to be known as and then select your location where the backup is located. This will then make your database with the name that you want.

And don't forget the login account either.

Administratorx