Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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 Tuesday, April 19, 2011 11:02 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 9:54 AM
Points: 1,720, Visits: 3,063
I think we have the regular bandwith just as other companies have.

Not sure how long it will take to copy 100gb files.
Post #1095834
Posted Tuesday, April 19, 2011 11:19 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Thursday, January 16, 2014 12:03 PM
Points: 21,376, Visits: 9,594
We're on a rather fast san here (48 1TB drives 15 K rpm.) It would take over 100 minutes to copy 100 GB.


One way to do it is to move the full backup whenever you have time. Then take a diff backup (will be 1-5 GB at the most). Restore those 2 files. Then take a tail log backup and finish the restore with it.

That can also give you extremely small downtime while you do the switch.
Post #1095844
Posted Tuesday, April 19, 2011 12:34 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 9:54 AM
Points: 1,720, Visits: 3,063
Thank you. That's a good idea.

What's the difference between transaction log back and log tail backup, so far I have not used log tail backup, when should we use it?
Post #1095896
Posted Tuesday, April 19, 2011 2:14 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Thursday, January 16, 2014 12:03 PM
Points: 21,376, Visits: 9,594
The tail backup is a way to say the "final" log backup to get the latest transactions since the diff.



As for compressing the backup, it might be worth spending the 2-8 hours it takes to do that and save some bandwith on the network. It wouldn't be an issue where I work, but it might be where you are...

after that the diff and tlog should just fly on the network in minutes.
Post #1095950
Posted Thursday, April 21, 2011 8:43 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Thursday, January 16, 2014 12:03 PM
Points: 21,376, Visits: 9,594
Here's an option I had never heard of. I used to do this manually but this is much better :

There's a way to both take the tail t-log and "shut down" the db at the same time so you're certain to really have everything. Tx gail.!

http://www.sqlservercentral.com/Forums/FindPost1096908.aspx
Post #1097048
Posted Thursday, April 21, 2011 9:09 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 9:54 AM
Points: 1,720, Visits: 3,063
Thanks, good tips.
Post #1097060
Posted Wednesday, September 21, 2011 9:35 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, March 06, 2014 6:13 PM
Points: 318, Visits: 1,183
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.
Post #1179154
Posted Thursday, September 22, 2011 2:26 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 5:15 PM
Points: 5,951, Visits: 12,822
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"
Post #1179217
Posted Wednesday, September 11, 2013 8:00 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 8:20 AM
Points: 177, Visits: 638
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?
Post #1493694
Posted Wednesday, September 11, 2013 8:31 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 8:43 PM
Points: 4,128, Visits: 5,836
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 at GMail
Post #1493718
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse