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

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

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Symptoms

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

Cause

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

Resolution

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

Work Around

The only work around is to perform command line flat file restore.  This procedure explains the steps necessary to generate a scxript and edit the script to use a clone pool instead of the primary backup pool. 
  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.
 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 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

database restore-general


database restore-monitor
Article Properties
Article Number: 000222645
Article Type: Solution
Last Modified: 01 Mar 2024
Version:  1
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.