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

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

本文章適用於 本文章不適用於 本文無關於任何特定產品。 本文未識別所有產品版本。
查看其他資源

症狀

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

原因

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

解析度

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
文章屬性
文章編號: 000222645
文章類型: Solution
上次修改時間: 01 3月 2024
版本:  1
向其他 Dell 使用者尋求您問題的答案
支援服務
檢查您的裝置是否在支援服務的涵蓋範圍內。