===Overview===
As any 3rd party tape database backup solution. The IBM Tivoli Data Protector, doesn't fall short on SUCKING at its job. 
The GUI might not work, the exe should be started with special CFG and OPT files so it will see the correct backups and so on and so on.
Here is how I have been able to use it to generate me the command which I used in the end :)

===Starting the GUI===
Now the GUI should be started with the special OPT and CFG files as the backup was taken so, something like this:

<sxh bash>
FlashCopyManager.exe /sqloptfile=V:\tsmscript\dsm_sql.opt /sqlconfigfile=V:\tsmscript\tdpsql.cfg 
</sxh>

After the GUI has started, you can go to recover, SELECT ALL BACKUPS and mark all the backups to restore which are needed, which means: 

Full backup + All log backups to the specified point.

After you mark them, right click and choose Restore to different location/instance.
This will give you larger menu, from which you can configure more things, like relocation directories, PIT settings and so on.



===Using commands===
The GUI, like every good "GUI" will generate commands to do his tasks, here you can see the commands which generated, which were executed:

<sxh bash>
Restore-DpSqlBackup Bolton_Belgium 
-Full 
-BackupDestination TSM 
-BackupMethod legacy 
-NoRecovery 
-SqlServer "(SERVER_NAME)ITMI1MSP38\(INSTANCE_NAME)SQLNAVISIONPROD,(PORT_NUMBER)2645" 
-SQLAUTHentication INTegrated -Stripes 1 
-FromSqlServer ITMI1MSP38\SQLNAVISIONPROD
-ObjectNames 20190219234524\000041F0 
-QueryNode DP -IntoDBName London_Snap_20190320 
-RelocateDir "X:\MSSQL10_50.SQLNAVISIONPROD\MSSQL\DATA\CH1393024,D:\MSSQL10_50.SQLNAVISIONPROD\MSSQL\Data\CH1393024" 
-MountWait Yes 
-ConfigFile X:\tsmscript\tdpsql.cfg 
-TsmOptFile L:\tsmscript\dsm_sql.opt
</sxh>

P.S. This script, will restore you the full backup and won't recover, meaning you can apply the transaction log backups and then finish with empty recover to open the database.
Please keep in mind that executing this command or the steps above only will leave the database in "Restoring" mode, meaning you will have to do empty recover, to open it.