Transfering Database?

[Karthick_gc]

How to transfer database from one system to other system?

[perle1]

Simply make a database backup and restore. :cool:

[Reza Raad]

you can do one way of these: 1-Backup from source database and Restore on destination, for this option your database server must be same 2-using Import/export tool from Integration service of Sqlserver, for this option database server doesn't matter usually.

Human knowledge belongs to the world http://www.rad.pasfu.com/index.php

[Senthil_M]

Detach the Database files (.mdf and .ldf). Move the files physically. Attach the files to the database. If previous log is required attach both .mdf and .ldf or else only .mdf can be attached.

[Karthick_gc]

What s mean by Detach?

[Senthil_M]

Karthik, Detaching means, removing database files from the server and files will remain in the same place without connecting to server. Check sp_detach_db sp_attach_db sp_attach_single_file_db Senthil