NMM: SQL Flat File Restore from Clone copy is not possible in the SQL plug-in UI

NetWorker Module for Microsoft (NMM) SQL Flat File Restore from Clone copy is not possible in the SQL plug-in UI.

NetWorker Module for Microsoft (NMM) SQL Flat File Restore from Clone copy is not possible in the SQL plug-in UI.
This is working as intended.

The select restore pool option is disabled in the UI during flat file restores.

Workaround:

The only workaround is to perform command-line flat file restore. This procedure explains the steps necessary to generate a script and edit the script to use a clone pool instead of the primary backup pool. 

1. Open NMM SQL plug-in UI.
2. Select Clear Cache. This clear previous selections and starts with new parameters.
3. Enter the NetWorker Server name. Click Update.
4. Select SQL Server host.
5. Select SQL Server instance.
6. Select the save set (database to restore).
7. Select the save time - this is important. Do this first before the next step.
8. Select Restore backups as files - leave the restore Folder for now, edit this later in the script.
9. Click Script button.
10. Copy the script. Open Notepad editor or similar text editor and paste the output script into the editor.
11. Add the following to the script; 

    -b clonepoolname  

12. Edit the FLAT_FILE_RECOVERY_DIR="NewDestination" for example, FLAT_FILE_RECOVERY_DIR="D:\RecoveryData" 

13. Save the script as batch file, for example, testsql.bat.
14. Open Command Prompt with Run as Administrator and run the testsql.bat script.

 For example this generated script:

nsrsqlrc.exe  -s linux1 -c win3.amer.lan -t "02/29/2024 08:58:18 AM" -S normal -a "SKIP_CLIENT_RESOLUTION=TRUE" -a "FLAT_FILE_RECOVERY=TRUE" -a "FLAT_FILE_RECOVERY_DIR=C:\Program Files\EMC NetWorker\nsr\tmp\backups" MSSQL:usertest1

After it is edited, it would have something like this to reflect -b clonepool and new recovery folder.

nsrsqlrc.exe  -s linux1 -c win3.amer.lan -t "02/29/2024 08:58:18 AM" -S normal -b ddclone -a "SKIP_CLIENT_RESOLUTION=TRUE" -a "FLAT_FILE_RECOVERY=TRUE" -a "FLAT_FILE_RECOVERY_DIR=C:\sharepoint\backup” MSSQL:usertest1