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. I want to make sure I can restore it completely in case of a failure.

  • @Nishant Did you find an answer to your question? If one of the posts below was a direct answer, you can accept it so that all future readers know the answer and also to reward the person who gave it. If none of the below posts are an answer, you can contribute an answer of your own and accept it to help future readers. – Wesley Jan 3 '11 at 20:42

As for the Windows Server portion, consider using wbadmin and scraping an image of the whole machine. Then save it to some kind of network drive. It's going to be a hefty size, so I hope you have some awesome throughput. Perhaps save it to a cloud drive in the same cloud provider.

Windows server backup uses VSS so you'll get everything on the drive, but perhaps you'll want to use the specific backup procedures for the individual database engines to make sure that your log files have appropriate checkpoints and flushes. Don't rely on images to protect your databases.

And of course, refrain from thinking in terms of "backups" and think in terms of "restores". Test your restores. Test your restoration procedures. It's no fun to need to restore and find you've had circular logging turned on. =(

| improve this answer | |

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.

| improve this answer | |
  • I would throw a encrypted VPN around the whole thing too. – Espennilsen Oct 19 '10 at 6:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy