April 19, 2011 at 11:34 pm
Hi,
One of our client has Group of companies.They have twenty different MS Sql Servers located at different places.At present they are taking backup of each server in Different places, where the server located.Now they want to make the centralize the backup. They r finding difficult to collect the backup data daily,because personally have to to each & every server to collect the data.
1. We cannot access each server from the main office 🙂
For this we need to create -
a. VPN
b. leased line.
or any other option?
What could be the speed of the data transfer .. ex: say each day need to transfer 500 MB in each server ..
Please suggests me the cheap & best solution . & justify it .. because i have to convince my manager ...
Thanks
Valla
April 20, 2011 at 7:25 am
You're in the wrong forum. This has very little to do with SQL Server. My company also has many databases offshore and do you know what I do when I need to work on one of those servers? I call the network guys to install the proper routers, VPNs, remote access tools, etc., because that is not what I do. Once the pipe is up, then I can do some database maintenance.
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
April 20, 2011 at 9:43 am
Other options:
-encrypt the file(s) and transfer via ftp
-transfer the files via secure ftp
In any scenario you probably want to look at compressing the file(s) unless you have a small amount of data or robust networking.
No one here can tell you the cheapest and best solution. Generally an internet based solution (vpn or ftp) will be cheaper than leased lines.
Preferably you client installs the appropriate networking infrastructure. And yes this question really belongs in a networking forum.
April 20, 2011 at 10:53 am
First, always back up locally. this ought to be scheduled and not a big deal.
If you are looking to transfer them to a central location, that's a copy function. Across teh Internet, FTP makes sense, and it usually is worth it to purchase some kind of compression utility from a third party to make the transfer quicker.
Leased lines are expensive, if you are not using them for something else during the non-backup transfer time.
VPN will work, but again, you want to minimize transfer, so compression helps.
April 21, 2011 at 9:22 am
I do this by taking these steps: 1. SQL script runs nightly at each location to create backup; 2. script (batch file) uploads those backups to a central FTP server; 3. script (batch file) on another designated server downloads from FTP to itself.......If you already have a useable FTP, that cost is minimal. Security concerns can be addressed by encrypted zipping or whatever else floats your boat.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply