Tech — 16 November 2010
Backup Microsoft SQL Server Online

Having worked with large installs of Microsoft SQL for the past twelve years, I know how difficult it can be to find a reliable and cost effective backup strategy.  The built-in backup functions of MSSQL leave much to be desired and using traditional backup strategies can be time consuming.  You need to change out tapes, log inventory, verify backups, make sure you’re taking them off-site, make sure their not missing off-site or sitting in someones trunk of their car.  In many of the traditional backup applications, you also need to pay additional licensing costs for each SQL server you want to backup.  You also need to address point-in-time recovery issues.  If you backup your MSSQL database at night and the server dies in the middle of day, you have just lost the past 12 hours or more of data and work.  You really need a “hot backup” solution that backs up all your data throughout the day.  There are many ways to approach this, but nearly all end in many thousands of dollars in capital expenditures in hardware, software, and personnel.  At the end of day, all you really want is a reliable solution that works and doesn’t cost a lot of money.

One of the best features of TyphoonBackup are “Live Backups”.  This has many uses, but one of the most valuable is the ability to backup your MSSQL server live throughout the day.  TyphoonBackup runs in the background without interfering with any of the functions of the database server and continually backs up the server database and transaction log files to the Amazon S3 Cloud.  The advantages of keeping your data in the cloud are startling.  The failure rates of tapes are very high, but with cloud storage, you’re guaranteed 99.99% availability and durability.  If you’re running your server in EC2, the backup is extremely fast.  If you have a catastrophic outage you can easily get your database files through the web or through the easy recovery function of TyphoonBackup.

Perhaps the most amazing news is the cost.  You can try it out for free using 100GB of space for 30 days for get 2GB free forever.  Plans start at just $10/month. You can get started in just a few minutes by downloading the software at the link below:

http://www.typhoontools.com

Related Articles

Share

About Author

(0) Readers Comments

Leave a Reply

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

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>