backup/restoring is a ideal answer to this problem but it will take lot of
time (first you have to backup it then you have to restore it with different
name) the fastest way to make copy of database is to just detach database
copy mdf and ldf file in new location and then attach the original and copied
database . because coping is OS specific operation therefore it is much
fester then backup and restore .

you can attach datbase by using this script

USE [master]
GO
CREATE DATABASE [NEW_DB_NAME] ON
( FILENAME = N'FILE PATH OF MDF' ),
( FILENAME = N'FILE PATH OF LDF' )
FOR ATTACH
GO

"KSor" wrote: