Automating database backups is a common challenge that developers face. When you manage multiple databases or your are supporting several clients who are using your database dependent software products, your concerns are grave. From informing and warning clients about the dangers of not backing up, some clients would still not backup regularly. If their system crashes and they loose their data, they become frustrated and begin to think that using electronic databases is not safe. The onus is on you the developer to ensure they can safely use their products to continue to be in business.
Automated backup software do exist, but the good ones with easy to use GUI’s are mostly expensive and way beyond the budget of most clients. We decided we should build something to take care of our client needs. So in the mist of several clients’ core demands which we are just trying to catch up with, we also had on our to-do list “setup a script to handle automated backups”, but pressing client requests has made us to continue pushing down this very important task. Then the pressure from backup preventable issues began to increase and we couldn’t postpone it anymore. Before we invest the time, we decided to search once more, and SQLServerBooster pops up. We downloaded and tried it. It’s exactly what we need. Designed by someone who had also faced the same problem a couple of years back.
SQLServerBooster is a free application for DBA’s, developers or people that do management around Microsoft SQL Server ® (2014, 2012, 2008, 2005 and 2000 – all editions including Express) and need to make backups automatically, compress and send through FTP, Amazon S3 ®, Amazon Glacier ®, Windows Azure ®, Dropbox ® or network.
Supports Database Engine databases and SSAS (SQL Server Analysis Services) databases.
Download and install SQLServerBooster. The installation is quite easy, just follow the wizard. The people who would need something like these would definitely not need to be guided in handling installations.
SQLServerBooster gives you a Wizard that let you configure and schedule a backup task.
To create a backup task you have three different options to accomplish this:
Step 1 Welcome screen
Step 2 Serer type, authentication, server, database and user configuration
Step 3 Backup information, type and compress options
Step 4 Choose the backup type and make another copies
Step 5 Configure FTP, Amazon S3, Amazon Glacier, Windows Azure and Dropbox
Step 6 Configure email, deleted old backups and scheduler
Step 7 Summary
Welcome screen
* Note: If the machine where SQLServerBooster it’s installed and MS SQL Server it’s installed are different, the authentication method has to be “SQL Server Authentication“, otherwise the SQLServerBooster Windows Service (SQLSBService.exe) will generate an error saying that because permissions was impossible to create the backup.
(^) Note: Backup “SSAS Remote Partitions” are not supported in this version.
(^) Note: Backup “SSAS Remote Partitions” are not supported in this version.
(ǂ) Note: If the backup is not compressed then it won’t be able to upload to the Cloud (Amazon S3, Amazon Glacier, Windows Azure or Dropbox) or send through FTP.
Each one of these configurations have their own specifications, choose the one(s) that you will use:
Gives a summary of the configuration, just to confirm that all is set as was conceived.
***************************************
Please encourage us by commenting