Conclusion

To transfer your database from one server to another, you can back it up and restore it on the target server, you can copy it while it is detached, and then attach the copy to the target server, you can use SQL Server's replication features, or you can use SSIS. Which method you choose depends on your application and your environment. You'll find the most versatility through a combination of SQL Server Agent and SSIS.

Chapter 4 Quick Reference

To	Do this
Create a database backup in SQL Server Management Studio	Right-click the database in Object Explorer, and select Tasks | Back Up.
Restore a database in SQL Server Management Studio	Right-click the Databases folder in Object Explorer, and select Restore Database.
Detach a database in SQL Server Management Studio	Right-click the database in Object Explorer, and select Tasks | Detach.
Attach a database in SQL Server Management Studio	Right-click the database in Object Explorer, and select Tasks | Attach.
Configure Peer-to-Peer Replication in SQL Server Management Studio	Right-click the Replication node in Object Explorer and select Configure Distribution from the context menu to run the Configure Distribution Wizard. Run this wizard on both servers in the replication group.
Set up an SSIS project	Open SQL Server Business Intelligence Development Studio (BIDS). Select File | New | Project, then select the Business Intelligence Projects node in the Project Types list and the Integration Services Project template from the Templates list. Add and configure connection managers, a data source, and a data destination.
Schedule a backup using SQL Server Agent	In SQL Server Management Studio, open the SQL Server Agent node in Object Explorer. Right-click the Jobs folder and select New Job from the context menu.