July 27, 2011 at 5:13 am
Hello,
I want to use log shipping for disaster recovery. But there are issues in transferin files to remote sites. There are few ways, but I don't know which one is better. I can use a VPN connection to the remote site and let sql put files in remote site! The problem with this solution is that if network connection fails, then the file should be tansfered again without resumption.Another solution is using some backup programs like veritas netbackup. The problem is that we are dependent to a third party. I don't know which advantages have Veritas over SQL?! I know it uses deduplication, but I compared it to the normal situation without using dedup, there where no difference.
Now....1-Can anybody tell me what is the best way to transfer file to the remote site when we are using log shipping? If we should use a software, which software do you recommend? 2-What is the best way to transfer full backup of DB to the remote site when the network connection is low on throuput.
Thanks
July 27, 2011 at 5:44 am
you can create a custom script in vbscript or other scripting language to transfer the files. Sort the files based on modified timestamp so that oldest file is copied first. Move the copied files in a different folder on the source server. schedule this script to run at a certain interval. Since bandwidth is an issue, it'd be wise to compress the files before copying them. Since u're using SQL Server 2008, you can take compressed backups of your dbs/log files.
July 27, 2011 at 9:01 am
I have one large file. An script has no advantage over SQL this way.
July 29, 2011 at 1:12 pm
Software like Double-Take might be able to help ease the pain of having a slow connection. It replicates data at the host level (below Windows) so it proves to be faster than anything you can do from within Windows (e.g. compress + xcopy/robocopy/copy etc.). Click on How It Works: Double-Take Availability
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply