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

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

Questo articolo si applica a Questo articolo non si applica a Questo articolo non è legato a un prodotto specifico. Non tutte le versioni del prodotto sono identificate in questo articolo.
Scopri le altre risorse

Sintomi

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

Causa

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

Risoluzione

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
Proprietà dell'articolo
Numero articolo: 000222645
Tipo di articolo: Solution
Ultima modifica: 01 mar 2024
Versione:  1
Trova risposta alle tue domande dagli altri utenti Dell
Support Services
Verifica che il dispositivo sia coperto dai Servizi di supporto.