Copy databases from one SQL Server to another

SQL Server provides you with several techniques you can use to copy a database from one server to another. For example, you can use the Data Transformation Services (DTS) wizards. Another technique you can use is to manually copy the database's files.

Click here for more....!