copy files through network to another server

Question

Post reply

copy files through network to another server

Viewing 7 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply

sqlfriend SSC Guru Points: 52781 More actions · Answer 1

sqlfriend

SSC Guru

Points: 52781

April 21, 2011 at 9:09 am

#1314565

Thanks, good tips.

Jacob Luebbers SSCarpal Tunnel Points: 4834 More actions · Answer 2

Sorry to necro an old thread - but just to answer your earlier question on the networked file copies - any method that uses an unbuffered copy will be fastest for files that size. If your servers are running 2008+ you can use xcopy /j - otherwise you'll need a seperate tool like ESEUTIL from an Exchange server.

Perry Whittle SSC Guru Points: 234013 More actions · Answer 3

If you dont already have a 3rd party backup product i would install the 2 week trial version of either LiteSpeed or SQLBackup and use this to compress the backups to up to 90%.

I had the same issues moving files from one data centre to another and used Litespeed to compress the backups. An 80GB native file dropped to under 7GB and made transfer much easier using XCOPY in restartable mode (wont copy ACLs though whereas Robocopy will).

Using diffs and logs as Ninja suggested can also help the process for very large databases

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

sql_novice_2007 Hall of Fame Points: 3307 More actions · Answer 4

Do I need to install the litespeed on the server or is it ok if I install it on my machine and compress the backup file from my machine?

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 5

sql_novice_2007 (9/11/2013)
Do I need to install the litespeed on the server or is it ok if I install it on my machine and compress the backup file from my machine?

All the third party backup compression tools I know of for SQL Server must reside on (i.e. be installed on) the server they are supposed to compress backups for.

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

paul.knibbs SSCoach Points: 15320 More actions · Answer 6

If you think about it, it has to work that way--otherwise, you'd be transferring the uncompressed data over the network in order to compress it, which would largely defeat the point of compressing the backup in the first place!

sql_novice_2007 Hall of Fame Points: 3307 More actions · Answer 7

sql_novice_2007

Hall of Fame

Points: 3307

September 11, 2013 at 10:28 am

#1649408

Got it.Thank you.