Configuring a good maintenance plan and monitoring it is a difficult task that requires deep knowledge and significant amounts of time, especially if you are not a database administrator (DBA).
QMB is a functional and convenient scheduler that is intended for performing database maintenance on Microsoft SQL Server.
By using an assistant, even novice administrators will be able to configure database maintenance in minutes while adhering to best practices and predefined sql server maintenance scripts:
At the same time, you can continue to use the maintenance plan for backups and maintenance of indexes and statistics.
The program has two built-in sets of SQL Server Maintenance Scripts:
Thus, the program has two sets of maintenance policy templates, which are based on the first or second set of tasks. When you create a policy from a QMB template, it will also check some of the database properties and optimize them, if necessary.
The predefined maintenance policy templates implement SQL Server backup best practices to ensure a Full and Simple Recovery Model. These strategies make it possible to optimize the use of disk space and to ensure a high restoration rate for most databases.
The program allows you to:
As the amount of data and the number of users increase, database performance decreases. Therefore, it is imperative to regularly maintain indexes and statistics. Predefined maintenance policy templates include such tasks as:
As you know, there is only one 100% verified method of checking your backups: you have to try to restore them. There is no other way. SQL Server backup best practices recommend that you make periodic restorations so that you can check your backup strategy and be ready to quickly correct accidents. QMB helps you automate this process to the maximum degree and allows you to:
QMB has implemented a XML restoration plan mechanism, which allows you to:
The program can be installed on any machine on the network!