Which is the best option used to move database from one server to another serve on same network?a) Import - Exportb)Backup-Restorec)Detach-AttachWhy?

Questions by shashibsaini   answers by shashibsaini

Showing Answers 1 - 14 of 14 Answers

lalita.p

  • Sep 18th, 2006
 

Import-Export is the best option used to move database from one server to another serve on same network.

It reduces the network traffic.

  Was this answer useful?  Yes

Ritesh Medhe

  • Sep 19th, 2006
 

Its very simple.

Take the latest backup of the database in any shared directory on the same server.

Copy the backup to the new server where you want to restore the database. Restore it using Enterprise Manager or SQL Query Analyser.

If you are restoring transaction Log backup be sure that you are attaching all the logfiles in the same sequence they were backed up followed by completed database backup. Also keep the database non-operational while restoring transaction log backup.

Thanks and Regards

Ritesh

  Was this answer useful?  Yes

Ranjit

  • Dec 6th, 2006
 

Copy the data files and transaction log files from your old SQL Server's hard drive (for example D:MSSQLData) to the new SQL Server's hard drive (to the same location, in this example, D:MSSQLData). Since we are copying all database files, including the system databases (like master, model, msdb, distribution), your server level settings, jobs, DTS packages, alerts, operators, logins etc. will be copied across.

  Was this answer useful?  Yes

Rajneesh Kaur

  • Dec 12th, 2006
 

Import-Export is the best feature to move a database coz' it doesn't need the same file system.whereas in Backup-Restore we need the same file system.Import-Export is more reliable

  Was this answer useful?  Yes

kirandba

  • Mar 31st, 2010
 

Backup and Restore works well and its also faster when compare to copying data and log file. Impoert/Export works well if your dealing with very small databases. If we have few million rows its takes minutes to copy when compared to seconds using backup and restore.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions