Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

We have several servers "in the cloud". These run web sites, sql server, postgres, etc...

The cloud service we're using (rackspacecloud) only allows backups up to 2GB, and our sql server and other instances are larger than that. We also have servers running at Amazon. We want to have a centralized backup of all our data that is agnostic as to which cloud service we're using.

So.. I'm looking for backup solutions that work across both Windows and Linux, can backup SQL and Postgres, and potentially handle local backups as well (backups of our in-office desktops and servers) which would include Small Business Server with exchange and local SQL Server instances.

I'm not looking for anything that's overly complicated to setup, and it must be secure (encryption of links as well as data on the remote servers in a manner that doesn't allow their employees to access the data).

Continuous backup would also be nice, but not truly necessary.

Does anyone have any suggestions for potential online backup services?

share|improve this question

2 Answers 2

up vote 0 down vote accepted

As for the database portions you'll need to configure the native database backup processes to dump to disk, and allow what ever product you use for remote backup to pickup those files and upload them. For SQL Server for example, you'll want to setup nightly full backups (as an example) will transaction log backups through out the day. Then the backup software (Mozy business for example) can grab the backups with the SQL Server has generated and upload them from the server to Mozy.

share|improve this answer
    
Yes, I'm aware of this method. I'm just looking for a more integrated backup solution. –  Erik Funkenbusch Dec 18 '10 at 19:41

If you click in the right places, the Rackspace Cloud Control Panel will let you create backups for slices over 2GB. There is a pretty simple tutorial here.

There is a caveat though:

The total size of the sparce disk file that your virtual hard disk resides upon cannot be larger than 160GB. What this means is that the highest amount of disk space in use at one time in your server’s history cannot have exceeded 160GB. If you were using more disk space than that in the past, you are basically SOL; the only way to make a backup image is to copy your data to a new server (assuming you have <160GB in use currently) and then take a snapshot of that new machine.

And (though unrelated) Linux servers cannot be backed up if they occupy more than 75GB of disk space, or 3 million inodes.

share|improve this answer
    
I've never seen such a helpful unhelpful answer. Lol. "If you click in the right place"??? I have clicked everywhere, and I can find no hidden way to do backups. –  Erik Funkenbusch Dec 18 '10 at 19:28
    
A link to the blog you quoted might have been halpful. I found it here failverse.com/… Unfortunately, I don't think this is valid anymore as Rackspace has recently changed their "with server" backup policy and now stores all images as cloud files. –  Erik Funkenbusch Dec 18 '10 at 19:44
2  
I did include a link. Reading is fundamental, sir. And this method applies to both Cloud Files and With-Server backups. Additionally, if you wish to have snapshot images be taken With-Server, you'll need to contact support. –  wittmaniac Dec 18 '10 at 21:16

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.