TDP SQL GUI more efficient for search restore point in allwaysOn cluster

Configuration:

AlwaysOn DB configured on TDP for database SQL with 11 instances (Active/Inactive) with more than 70 SQL databases with MMC.

Problem:

When selectively restoring inactive data for a particular database, it takes a long time, up to 45 minutes or sometimes much longer, for the database list to appear. Once the inactive data is selected, all inactive records of all databases are displayed. There is no filter in the MMC GUI to request and display only inactive data of a single database from the SP server.

The SQL Administrator knows at the restore time which database to restore. A list of all inactive backup of all databases is not necessary.

With the CLI it is possible to display only the records, inactive or active, of a specific database. This way we do not have a long waiting time to display the inactive records of a database.

The waiting time of 40 minutes is not acceptable for the SQL database administrator.

The wait time of 40 minutes does also not meet the requirements of ITSCM management for an ransomware desaster.

The splitting into several alwaysOn clusters is not feasible for the company.

Solution:

In the MMC GUI, there must be a filter or dropdown menu to make a selection of a database before requesting data from the SP server. Afterward this data are displeyed in the MMC GUI for restore process.

The easiest way is to use a dropdown list with the available databases. If a database is selected, only the active and inactive records from this database will be requested from the SP server and displayed in the MMC GUI for restore.

It is important to request only the active/inactive records of a single database and not of all databases from the SP server. This will prevent the long waiting times.

Benefits:

Meet ITSCM management requirement for ransomware

Faster restore process

Better acceptance for database administrators