I was able to get handybackup to successfully backup my MS SQL database on my
Windows web host. Below are the screenshots and some of the issues I ran into. This article is a continuation of my other article on how to backup my SQL databases from your web host automatically on schedule.
==================== wrong database driver ====================
I had several failed attempts at creating a connection to the database when
using the MySQL ODBC 3.51 driver. One of the support technicians did not
understand the question I was asking him about which driver to use. Finally when
my support ticket was escalated I was given the correct answer. “SQL Server” is
the correct driver to choose when downloading in MS SQL database using
handybackup. This is different if you are backing up a database that is on your
local machine.
==================== restoring ====================
The database I was backing up is a critical database to my business so I have
not attempted to restore my backup yet. I was able to restore my SQL databases
using handybackup on my other web host. I should probably try to restore it so
that I know I am covered… I will need to wait for the right time to do it and
also check with my web host support on my options if things go wrong.
==================== result ====================
My MS SQL database is automatically backed up every week to my local hard drive.
Happy happy joy joy.
Related Articles
3 users responded in this post
[...] Here are some screen shots of me setting up Handy Backup 6.1 to automatically download the MySQL databases I have on my shared web hosting company. Getting this all setup took me a couple hours because I didn’t have the right MySQL connector driver installed on my Windows XP machine. Once it was installed everything went smoothly. If you don’t have the “MySQL ODBC 3.51″option available in the create new data source window wizard then you can download it here. If you need to download/backup an MSSQL database automatically on schedule please see this post. [...]
[...] database instead of the one on my other slower web host. This is a follow-up to this article: download/backup an MSSQL database automatically on schedule please see this post Here are the [...]
I updated this article when I moved the database…. details here:
http://www.wesedholm.com/?p=287
Leave A Reply