Recovering SQL, Exchange, or SharePoint items from virtual machine backups with Ontrack® PowerControls™
To recover items from a host-level backup or copy, you will use the backup appliance to create a recovery object containing the backup's files, then use Ontrack PowerControls to view and recover application items.
See these procedures for details:
To recover SQL items from a backup or imported backup copy
1. Log in to the backup appliance.
2. Select Recover and click the Backup Catalog tab.
(Optional) Use Filter Backups to the right to customize the backups that display. For details, see Working with custom filters.
3. Expand the asset and select the backup or imported backup copy from which you want to recover items.
(To import a backup copy, see To import a cold backup copy or To import a hot backup copy.)
4. Click Recover Files.
5. Click Confirm to continue. The appliance creates the recovery object.
NOTE If you receive an error on a Unitrends Backup appliance while creating the recovery object, increase the memory allocation for the Unitrends Backup VM by using the host that manages it.
6. Click View FLR.
7. On the File Level Recovery tab, locate the recovery object.
Recovery objects display on the tab with the following details: the name of the VM asset for which the object was created, the status of the object, the date and time it was created, the length of time it has existed on the appliance, and whether it can be accessed through iSCSI or CIFS.
8. Select the recovery object and click Browse/Download.
NOTE In most cases you can browse the recovery object directly in the appliance UI by clicking Browse/Download. If this method is not supported in your environment, the Browse/Download button is disabled and you will need to mount a CIFS share or iSCSI LUN on a target machine instead, as described in To recover files by mounting the CIFS share or To recover files by mounting the iSCSI LUN.
9. In the File Browser, browse to the SQL instance whose items you will recover. Note the filepath as you will browse to it in Ontrack PowerControls® for SQL™.
In our example, the path is volume1\ProgramFiles\Microsoft SQL Server\MSSQL 15.MSSQLSERVER\MSSQL\DATA.
10. Launch Ontrack PowerControls® for SQL™.
11. Select File > Open Source. Click Add.
12. Enter \\ followed by the appliance IP address to create a network mapping to your Unitrends appliance. For example, \\192.168.225.24.
13. Browse under the flr folder to the SQL data path you noted above in step 9. .
NOTE An flr folder exists for each recovery object that displays on the File Level Recovery tab in the appliance UI. In our example, there are two recovery objects: flr15 and flr226.
14. Select databases and logs. Click Open.
15. Click Next.
16. Select the target server, authentication method/credentials, and database. Click Finish.
17. Selected databases/logs display in the Source area. If needed, select File > Open Source > Add to add more databases/logs.
18. Locate tables to restore by browsing databases in the Source area. Copy and paste (or drag) a table from a SQL database backup (source) into a live SQL database (target). For additional detail, see Restoring Microsoft SQL Server Tables in the Ontrack® PowerControls™ User Guide for SQL.
19. When you have finished recovering items, remove the recovery object:
● Return to the appliance UI. On the File Level Recovery tab, select the recovery object and click Remove. Click Confirm.
● The recovery object is removed:
To recover Exchange items from a backup or imported backup copy
1. Log in to the backup appliance.
2. Select Recover and click the Backup Catalog tab.
(Optional) Use Filter Backups to the right to customize the backups that display. For details, see Working with custom filters.
3. Expand the asset and select the backup or imported backup copy from which you want to recover items.
(To import a backup copy, see To import a cold backup copy or To import a hot backup copy.)
4. Click Recover Files.
5. Click Confirm to continue. The appliance creates the recovery object.
NOTE If you receive an error on a Unitrends Backup appliance while creating the recovery object, increase the memory allocation for the Unitrends Backup VM by using the host that manages it.
6. Click View FLR.
7. On the File Level Recovery tab, locate the recovery object.
Recovery objects display on the tab with the following details: the name of the VM asset for which the object was created, the status of the object, the date and time it was created, the length of time it has existed on the appliance, and whether it can be accessed through iSCSI or CIFS.
8. Select the recovery object and click Show Details. The CIFS path shows the appliance IP and flr folder (flr9 in our example). Note the name of the flr folder. You will need it to access the EDB file in Ontrack PowerControls® for Exchange™.
NOTE An flr folder exists for each recovery object that displays on the File Level Recovery tab in the appliance UI.
9. Select the recovery object and click Browse/Download.
NOTE In most cases you can browse the recovery object directly in the appliance UI by clicking Browse/Download. If this method is not supported in your environment, the Browse/Download button is disabled and you will need to mount a CIFS share or iSCSI LUN on a target machine instead, as described in To recover files by mounting the CIFS share or To recover files by mounting the iSCSI LUN.
10. In the File Browser, browse to the mailbox database whose items you will recover. Note the filepath as you will browse to it in Ontrack PowerControls® for Exchange™.
In our example, the path is volume1\Program Files\Microsoft\Exchange Server\V15\Mailbox\Group2 Database.
11. Launch Ontrack PowerControls® for Exchange™.
12. Enter the following in the Data Wizard Source Selection dialog:
NOTE If the Data Wizard does not display, select File > Open Source.
● Select Source – Select EDB File in the Select Source area.
● EDB Path – Browse to the EDB file or enter the full UNC path to the EDB file. In our example, the full UNC path is \\[ApplianceIP]\flr9\volume1\Program Files\Microsoft\Exchange Server\V15\Mailbox\Group2 Database\Group2 Database.edb.
● Log File Path – Browse to or enter the full UNC path to the log file directory. In our example, the full UNC path is \\[ApplianceIP]\flr9\volume1\Program Files\Microsoft\Exchange Server\V15\Mailbox\Group2 Database.
13. Click Next.
14. In the Data Wizard Target Selection dialog, specify the location where items will be recovered. In our example we are recovering to an Outlook Data File.
15. Click Next.
16. To recover items, do one of the following:
● To recover items to a PST file or live Exchange environment, navigate to the items you want to recover in the Source pane on top. Copy and paste (or drag) them to the Target pane.
● To recover items to a network location, navigate to the items you want to recover in the Source pane on top, select them, right click and select Export, select a message format and recovery location, and click Export.
For additional detail, see the Ontrack® PowerControls™ User Guide for Exchange.
17. When you have finished recovering items, remove the recovery object:
● Return to the appliance UI. On the File Level Recovery tab, select the recovery object and click Remove. Click Confirm.
● The recovery object is removed:
To recover SharePoint items from a backup or imported backup copy
1. Log in to the backup appliance.
2. Select Recover and click the Backup Catalog tab.
(Optional) Use Filter Backups to the right to customize the backups that display. For details, see Working with custom filters.
3. Expand the asset and select the backup or imported backup copy from which you want to recover items.
(To import a backup copy, see To import a cold backup copy or To import a hot backup copy.)
4. Click Recover Files.
5. Click Confirm to continue. The appliance creates the recovery object.
NOTE If you receive an error on a Unitrends Backup appliance while creating the recovery object, increase the memory allocation for the Unitrends Backup VM by using the host that manages it.
6. Click View FLR.
7. On the File Level Recovery tab, locate the recovery object.
Recovery objects display on the tab with the following details: the name of the VM asset for which the object was created, the status of the object, the date and time it was created, the length of time it has existed on the appliance, and whether it can be accessed through iSCSI or CIFS.
8. Select the recovery object and click Browse/Download.
NOTE In most cases you can browse the recovery object directly in the appliance UI by clicking Browse/Download. If this method is not supported in your environment, the Browse/Download button is disabled and you will need to mount a CIFS share or iSCSI LUN on a target machine instead, as described in To recover files by mounting the CIFS share or To recover files by mounting the iSCSI LUN.
9. In the File Browser, browse to the SharePoint instance whose items you will recover. Note the filepaths to the MDF and LDF files, as you will browse to them in Ontrack PowerControls® for SharePoint™.
In our example, the paths are volume1/Program Files/Microsoft SQL Server/MSSQL13.MSSQLSERVER/MSSQL/DATA/SharePoint_AdminContent_bd2a51ae-feac-4a66-aa42-967b825c50a3.mdf and volume1/Program Files/Microsoft SQL Server/MSSQL13.MSSQLSERVER/MSSQL/DATA/SharePoint_AdminContent_bd2a51ae-feac-4a66-aa42-967b825c50a3_log.ldf.
10. Launch Ontrack PowerControls® for SharePoint™.
11. Select File > Open Source. Click Add.
12. Enter \\ followed by the appliance IP address to create a network mapping to your Unitrends appliance. For example, \\192.168.225.24.
13. Browse under the flr folder to the SharePoint data folder you noted above in step 9. .
NOTE An flr folder exists for each recovery object that displays on the File Level Recovery tab in the appliance UI. To see the name of the SharePoint flr folder, select the SharePoint recovery object on the File Level Recovery tab and click Show Details.
14. Select databases and logs. Click Open.
15. Click Finish.
16. Selected databases/logs display in the Source area. If needed, select File > Open Source > Add to add more databases/logs.
17. Select File > Open Target.
18. Select the target server and enter authentication information. Click Next.
19. The target SharePoint server displays in the Target area.
20. To recover items, select files in the Source area and copy/paste (or drag) them to a library on the target. For additional detail, see the Ontrack® PowerControls™ User Guide for SharePoint.
21. When you have finished recovering items, remove the recovery object:
● Return to the appliance UI. On the File Level Recovery tab, select the recovery object and click Remove. Click Confirm.
● The recovery object is removed:
