• I would recommend using Backup and Restore. Much easier and if something is incorrect, you still have the original database up and running. Also, how do you plan to transfer the logins? The Users in the database will go with the database, but the mating Logins will not. You will have to either transfer them, or drop them all and re-create them on the other box.

    All of this is in the SQL Books Online. Have you read any of the material there? If gives you syntax for all SQL code that you need. You can use the SSMS Interface as well if you are comfortable there. Both preform the same tasks. Meaning, a backup command in T-SQL will get you the same thing as if you right click and select Backup from the list.

    I would leave the original alone until you get the database on the other box up and running the way you want. That means, using Backup and Restore, or creating an SSMS package to pump everything over. I would also create a full backup of the original just before you begin. You can always restore that if you really need too. But once you have a backup, copy it over to the other box and restore it.

    Andrew SQLDBA