NetWorker - NMM SQL Flat File Restore from Clone copy is not possible in SQL Plugin Gui

Work Around

1. Open NMM SQL Plugin gui.
2. Select Clear Cache.  This clear pervious 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 next step.
8. Select “Restore backups as files” – leave the restore Folder for now – we will edit this later in script.
9. Click Script button.
10. Copy the script.  Open Notepad editor or similar text editor and paste the output script into 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. NOTE – RECOVERY_DIR Must already exist.
14. Save the script as batch file eg. testsql.bat 
15. Open Command Prompt with Runas Administrator and run the testsql.bat 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

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