SQL Server - Which is the best option used to move database from one server to another serve on same network?a) I

GeekInterview.com > Interview Questions > Database > SQL Server

Go To First | Previous Question | Next Question

SQL Server | Question 49 of 99

Which is the best option used to move database from one server to another serve on same network?
a) Import - Export
b)Backup-Restore
c)Detach-Attach

Why?

Total Answers and Comments: 5

Last Update: December 24, 2008 Asked by: shashibsaini

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

September 18, 2006 09:26:36

lalita.p

RE: Which is the best option used to move database fro...

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

It reduces the network traffic.

Is this answer useful? Yes | No

September 19, 2006 07:08:03

Ritesh Medhe

RE: Which is the best option used to move database fro...

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

Is this answer useful? Yes | No

December 06, 2006 21:21:04

Ranjit

Member Since: October 2005 Contribution: 18

RE: Which is the best option used to move database fro...

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.

Is this answer useful? Yes | No

December 12, 2006 06:51:57

Rajneesh Kaur

RE: Which is the best option used to move database fro...

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

Is this answer useful? Yes | No

December 24, 2008 03:10:03

tariqueabro

Member Since: December 2008 Contribution: 1

RE: 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?

backup-restore

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank