I've always used the Copy Database Wizard.

I've used this as well, in 2000, it doesn't exist in 7. :/

Frankly, it's been a while since I used SQL server...

Same here. I last used it about 2 years ago working with Cisco Collaboration Server and other Cisco stuff.

The only reason I'm doing this in the first place is because I volunteered (mistake), everyone else was too scared to even touch it (especially the network manager), and we don't have a DBA. Out of all the people here, I have the most SQL Server experience, which is very scary.