Friday, January 28, 2011

How can I backup a remote dedicated Server 2008 to my own computer at home?

My server 2008 has mysql databases, SQL Server databases, and multiple websites. How do I back this information up? I have setup the dedicated server to have two 300GB hard drives and they are both mirrored. I want to make sure that I have a backup somewhere else as well.

If it's not my home server, I don't mind backing up somewhere else either but I want to make sure I can restore it completely in case of a failure.

  • I use a combo of mysqldump, tar (or zip), and sftp. I find that Capistrano (a ruby ssh wrapper) is useful to tie everything together in one place, but it's not necessary. Use mysqldump and zip on the remote server, then run a scheduled job on your home server to sftp them from remote to home.

    Espennilsen : I would throw a encrypted VPN around the whole thing too.
    From Bill

0 comments:

Post a Comment