This step-by-step article describes how to move SQL Server user databases and most common SQL Server components between computers that are running SQL Server.
The steps described in this article assume that you will not move the master , model , tempdb , or msdb system databases. The steps provide different options for you to transfer logins and most common components contained in the master and msdb databases. For more information about moving system databases, see the Microsoft Knowledge Base articles listed in the "Step 1: How to Move User Databases" section of this article. Additionally, if you transfer the system databases, do not follow "Step 2: How to Transfer Logins and Passwords" through "Step 5: How to Move DTS Packages".