Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

copy files through network to another server Expand / Collapse
Author
Message
Posted Sunday, April 17, 2011 6:35 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, May 16, 2016 11:46 AM
Points: 1,914, Visits: 3,587
I'm planning to upgrade sql server 2005 to 2008. For now I'm just planning on it. If we use side by side upgrade, we will have to either copy data files to another server, or copy backup files to another server.
They are quite large size files. What are the best way to copy them? Currently, I only know manually use copy then paste to another \\serverB\$D\Data or \\serverB\$D\backup. Any other way of doing that for faster copy?

Thanks
Post #1094682
Posted Sunday, April 17, 2011 9:16 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 10:21 AM
Points: 40,541, Visits: 37,779
Restore from tape maybe?

--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

Helpful Links:
How to post code problems
How to post performance problems
Post #1094695
Posted Monday, April 18, 2011 2:09 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, May 26, 2016 2:41 AM
Points: 1,797, Visits: 6,079
Jeff Moden (4/17/2011)
Restore from tape maybe?


Of course, if they don't have the tape drive directly connected to the SQL server itself (or SAN, if they're using one) that would just come back to a network transfer under a different name...
Post #1094773
Posted Monday, April 18, 2011 5:11 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 10:21 AM
Points: 40,541, Visits: 37,779
That, most definitely, would be true.

--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

Helpful Links:
How to post code problems
How to post performance problems
Post #1094833
Posted Monday, April 18, 2011 7:11 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:37 AM
Points: 5,206, Visits: 7,586
I have helped several clients with this and often the fastest mechanism is USB drive(s). If you do have multiple USB 2.0 ports on separate busses on the server you can get good very good transfer rates. Write out your backups to a number of files equal to the USB drive count. If you are at the high end I have even had companies buy cheapo direct attached storage and moved files that way. Sneakernet can be WAY faster than the existing network, and it doesn't affect existing operations either.

Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #1094903
Posted Monday, April 18, 2011 8:08 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:30 AM
Points: 14,326, Visits: 37,420
I had to lookup Sneakernet on Wiki , already anticipating installing something ultra fast on my network;

That one made my day.


Lowell

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Post #1094994
Posted Monday, April 18, 2011 10:46 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, May 16, 2016 11:46 AM
Points: 1,914, Visits: 3,587
The total size files are about 100 gb.

Can I use RoboCopy, never used it before, just heard it is faster?

Do I need to download something in order to run the command, and what is the syntax to copy all the files from one server to another?

Thanks
Post #1095151
Posted Tuesday, April 19, 2011 1:36 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, May 26, 2016 2:41 AM
Points: 1,797, Visits: 6,079
I can't see any reason why Robocopy would be any faster than using a normal copy from a command prompt--it's not like it compresses the data it's copying or anything like that! It might be a bit faster than copying using the GUI, but even then, probably not enough of a difference to be worth worrying about.

How big are the files we're talking here, anyway?
Post #1095446
Posted Tuesday, April 19, 2011 9:35 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, May 16, 2016 11:46 AM
Points: 1,914, Visits: 3,587
The total size may be around 100gb.
Post #1095746
Posted Tuesday, April 19, 2011 10:59 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, April 29, 2016 1:02 PM
Points: 327, Visits: 1,125
If you have limited bandwith, you could zip the backup to make it smaller.

Keep in mind, it will take some time to zip and unzip the backup, so this only really saves you time if you have limited bandwidth.




Post #1095831
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse