ISP DP for SQL Powershell in AlwaysON Environment / restore Script

This Script (Command Line Interface) allows us to do faster restore compare to the Graphical User Interface.

MMC GUI has long wait time when restore inactive backup's as described in the case (TS004928519). In a case of ransomware we can't accept this situation.

The challenge is to get for restore operation the parameters Date and Time automatically the needed ObjectID.
Here the IBM Script must look for all Objectiv of the DB which are needed for the period.
If the time is e.g. 14:00 and the log contains data from 13:30 to 14:30 the last log must be applied only to 14:00.
generated are then all tdpsqlc restore commands which are necessary for it.

# with CLI Wizzard
generate_restore_mssql.ps [GENERATE]
generate_restore_mssql.ps GENERATE=YES

The script (Example: generate_restore_mssql.ps) which ask's the dba for all nessesary paramters needed for such a restore.

With CLI directly create the restore [dbname]_restore_mssql.ps script with the tdpsqlc commands like:
generate_restore_mssql.ps [Database] [FromSql] [AlwysOn] [RELOCATEDir] [RELOCATELog] [untildate] [untiltime] [RECOVERY] [OPTIONFile]

generate_restore_mssql.ps Database=TEST_TSM FromSql=SQL-AG-L81 AlwysOn=Y RELOCATEDir="P:\SQL06_Data\TEST_TSM_restore" RELOCATELog="P:\SQL06_Log\TEST_TSM_restore\" untildate="01/04/2022" untiltime="07:00:00" RECOVERY=YES OPTIONFile=restore_mssql_

The script script should have the possibility commands to be generated (for simple users) or even for advanced user to add additional restore options.
In addition we would also recommend to use different like restore_mssql_dsm.opt files / restore_mssql_tdpsql.cfg / restore_mssql_log-control.log files which doesn't interfear any the current tasks / running tasks during restore operation (like hourly Log backup / database backup and others).