How to backup your “MSSQL” database from your web host automatically on schedule. Includes screenshots

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.

 

3 thoughts on “How to backup your “MSSQL” database from your web host automatically on schedule. Includes screenshots

Leave a Reply

Your email address will not be published. Required fields are marked *