Collapse All Expand All

QMB is a Microsoft SQL database maintenance tool. If you are not a database administrator, then setting up maintenance can take a lot of time and effort. You'll need to choose a restoration model for your databases, configure backups, find the right scripts for maintaining indexes, arrange all these tasks in the correct order, create a schedule, and so on. But even doing that, you can't be sure that it's all working the way it should. For example, it may happen that during a malfunction you are unable to restore a database from a backup. This may occur for many reasons: a disk error, or a broken chain of backups. Likewise, if you don't configure notifications, then you won't find out in time that the creation of a backup has failed — for example, because the disk has run out of space.

Our goal was to create a simple and intuitive tool that will help beginners configure reliable database maintenance in minutes. At the same time, we tried to make our solution convenient for advanced users. For example, you can add your own scripts (tasks). When tasks are executed, all messages that a script has outputted are recorded into the maintenance log, as if it were executed in SSMS

Key features:

• Easy & quick configuration of maintenance policies for Microsoft SQL Server: backups, integrity check, maintaining indexes and statistics and so on
• Built-in maintenance policies for the majority of database types
• A set of built-in tasks, including the popular OLA Hallengren scripts
• Maintenance of databases on several SQL servers from a single copy of the program
• Running T-SQL, CMD, PowerShell, VBS, JavaScript and other scripts according to a schedule.
• Copying of maintenance policies
• Backup copying on a networked folder
• Creating an XML restoration plan
• Automatic restoration from backups on a local or remote SQL Server
• Keeping database copies updated on a local or remote SQL Server
• Monitoring of free disk space on SQL server disks
• Storage of database size change statistics. Calculation of the average data increment value
• Email notifications
• Full logging, including all messages received in the course of task execution.