Periodic backing up of databases running on a production server is of utmost importance for any business. Gone are the days when DBA’s used to spend lot of time performing Sql backup & recovery activities manually. These days we have good number of software’s which can completely automate the database backup & recovery process. Today we will be reviewing one such software called Sqlbak.
Sqlbak can help you to schedule & restore the SQL database from the web browser itself. In addition to Backup & recovery, Sqlbak can also monitor the database for you. As the first step, you need to install the Sql backup client app on your SQL server machine. Once you have sqlbak app installed & configured on the server, you will be able to manage the SQL server from the web browser. From your account in the Sqlbak.com, you can create & schedule a job to completely automate the sql backup activity. As part of the job configuration, you will have options to configure how often you want to backup the database, where to dump the backup data and a host of other useful features. You can do all the configuration related backup, recovery & monitoring directly on the web. You will not be required to do any configuration on the SQL server. Sqlbak is currently being used by more than 1500 companies worldwide.
Key Features of SqlBak
Below are the 5 key features of Sqlbak,
Schedule SQL Backup
By using your account on the sqlbak.com, you can schedule the server backup to one or more of the destinations chosen by you. You can select one or more of the databases you wish to backup from the Sql server. The backup destination could be either Google Drive, OneDrive, Amazon S3, Dropbox, FTP folder or a local folder on the same server.
2. Restore SQL Backup
Once the database if backed up, the tool lets you to restore the same data on a different Sql server as well. This feature could be quite useful especially in cases where you may need to provide access to production data to your development teams to fix any urgent production issues.
3. SQL Server Monitoring
The Sqlbak software will continuously monitor the health & performance of the SQL server. It can send notifications in cases like when server goes down or when database size exceeds certain limit.
4. Real time notifications
The tool can send email notification’s in real time to update you on the status of the scheduled job. You can also receive notifications when there are issues with Sql server performance or health. These notifications can help you to analyze & quickly rectify the problems if any.
5. Web Based Configuration & Management
Unlike tools like SQLBackupAndFTP which wold require you to login to the Sql server to manage your backup and recovery tasks, sqlbak enables you to do all this from the web. Installation of Sqlbak client is the only task you will be required to do outside the web. All other configurations related to Sql backup, recovery & monitoring can configured and managed from the web.
As you can manage everything from a single dashboard, Salbak makes it easy for you to manage large number of databases. You can use the Sqlbak tool for managing up to 2 databases on server for free of cost. You can checkout their Plans & Price sections for completed details on their commercial plans.