In SSMS 2008 you can do this:
-
Create a backup of the database you want to copy
-
In SSMS, right-click ‘Databases’ and select ‘Restore Database’
-
Select the database you wish to copy from the ‘From database’ drop-down list in the ‘Source for restore’ section
-
Enter the name of the new database in the ‘To database’ field in the ‘Destination for Restore’ section – this cannot be the name of an existing database.
-
Click OK
You’re done! 🙂