duplicate database

hi,

I am using SQL Server 2000 and i wanted to know what is the best way to duplicate a database?

back it up and then restore it to another database, or use the copy objects option in the Import Export Wizard|||Hi,

you coudl either do a backup and restore or if you have a maintaince window you can stop the service, copy the databases and attach the copies them after restarting the service again.

HTH, Jens Suessmeyer,

http://www.sqlserver2005.de