Any ideas-quickest way, how to transfer a 200GB mdf file from one server to another?
Tell me more
×
Server Fault is a question and answer site for
professional system and network administrators. It's 100% free, no registration required.
|
migrated from stackoverflow.com Feb 11 '10 at 14:24
|
I would make moving it safely the first priority, and speed second. Safest way is to backup and restore, that could be made faster using backup compression tools such as litespeed - would result in a smaller file to copy / restore. Less-safe options will be dettach / attach etc. |
|||
|
|
|
Massimo recently asked a question that is somewhat similiar, albeit he was talking about a high-latency network. You don't specify what kind of network it is (gigabit Ethernet LAN, some kind of WAN, etc), but the answer I gave there might give you some ideas, as well. In particular, the uftp utility that I suggested gave Massimo some pretty decent-looking results on his high-latency WAN. I haven't gotten a chance to test it yet over a gigabit Ethernet LAN but from its description it sounds like it would do a pretty good job of filling up a pipe. It uses multicast IP to do the copying, so if you only end up needing to copy the file to multiple locations this tool would be a "win" immediately since the file only needs to traverse the network once to be received by an arbitrary number of destinations. |
|||
|
|
|
I would probably use the Microsoft eseutil tool. It's not specifically for this purpose (it's a tool to move large exchange databases around) but can be used for other databases and logs. From Microsft: "Depending on disk and network conditions, copy file mode may be able to copy a file up to 20 percent faster than a normal copy because the copy file mode in Eseutil copies files in larger blocks of data." More info at Microsoft here. |
|||||
|
|
Well my first thought would be netcat, if you are on a Gigabit Network this should work rather quickly. Netcat Examples |
|||
|
|
|
Richcopy seems a good alternative (from this post) if you can guarantee your local network runs at a decent speed. |
|||
|
|
|
Can I use Eseutil to transfer stuff from one server to anohter? Both of them are located on a different location. Yes I can use FTP. |
|||
|
|
