SIRIS, ALTO and NAS: Granular SQL restore with Ontrack PowerControls (Kroll restore)



This article explains the process to perform a granular Microsoft SQL database restore using Ontrack PowerControls. Ontrack PowerControls supports SQL 2005, SQL 2008, SQL 2008 R2, SQL 2012, and SQL 2014 and can read MDF, LDF, NDF, and BAK files. To restore an Exchange server, see SIRIS, ALTO, and NAS: Exchange mailbox restore with Ontrack PowerControls (Kroll restore).

To learn more about PowerControls' restore capabilities, see Ontrack PowerControls User Guide Version 9.3 for SQL (external link).

Datto appliances use Ontrack PowerControls version 9.3. Newer versions of this software are unsupported.


  • Datto SIRIS
  • Datto ALTO
  • Ontrack PowerControls
  • Microsoft SQL Server


The restore process has several steps:

 Download Ontrack PowerControls

1. Download and install Ontrack PowerControls for Microsoft SQL Server on a Windows PC that can connect to the Microsoft SQL Server.

2. Log in to the web interface for your Datto appliance. Go to the Advanced menu and click Granular Restore. Under Kroll Ontrack PowerControls for Microsoft SQL Server, click the Executable and the License File links to download each file.

Figure 1: Download Ontrack PowerControls for MS SQL Server (click to enlarge)

If you need to restore Microsoft SQL Server 2016, use the Kroll Ontrack PowerControls for Microsoft Exchange and SharePoint installer and license. Then, follow the steps described in this article to complete the restoration. To learn how to install Kroll Ontrack PowerControls for Microsoft Exchange and SharePoint, see our Exchange article.

3. Once you've downloaded the executable and the license file, you can install and activate the program. You do not need to install PowerControls on the MS SQL server, but you must be able to connect to the SQL server from the machine on which you install it.

Check the Microsoft SQL Server datastore

1. To navigate to the correct location to retrieve your data, you must know where your SQL server stores this data. To do so, go into the Microsoft SQL Server program. Right-click the top-level server, and choose Properties. This example shows SQL Server 2008. Other versions of SQL Server may differ.

 Figure 2: SQL Server 2008 (click to enlarge

2. In the Server Properties window, click the Database Settings option.

Figure 3: Database Settings (click to enlarge)

Note the location of the Data and Log files. You will need this information later.

Mount a file restore

1. To start the file restore, click the Restore tab of the Datto appliance. 

Figure 4: Start a Restore (click to enlarge)

2. Choose the SQL server from which you want to restore data and select File Restore. Then, choose the recovery point that has the data that you need.

3. Click Start File Restore.

Figure 5: Mount Recovery Point (click to enlarge)

4. Click the Mount button, and make a note of the Samba Share information.

Figure 6: Samba Share information (click to enlarge)

Use Ontrack PowerControls to connect the data source and SQL Target

1. In the Ontrack program, go to the File menu and click Open Source.

Figure 7: Open Source (click to enlarge)

2. Navigate to the data source, choose the *.mdf file, and click Open.

Figure 8: Select the data file (click to enlarge)

3. In the Data Wizard window, click the Add... button.

Figure 9: Data Wizard (click to enlarge)

4. Add the log (*.ldf) file.

Figure 10: Add the *.LDF file (click to enlarge)

5. You will see the Data Wizard with both the *.MDF and *.LDF files listed.

Figure 11: Source files added (click to enlarge)

6. Click the Finish button. A green bar will display progress.

Figure 12: Open Source progress (click to enlarge)

Copy source to target

1. The Data Wizard prompts you to select your target server. Enter your credentials to connect to the Microsoft SQL Server. Then, choose the database you need to restore. In Figure 13, it is connecting to the localhost and connecting to the DattoDummyDataSQL database.

Figure 13: Connect to Target Server (click to enlarge)

2. When you click Finish, you will see a window with both the Source and Target visible. You can drag and drop the table you wish to restore. Figure 14 depicts a drag and drop of the dbo.employeesdemo table from the Datto file restoration to the DattoDummyDataSQL live database.

Figure 14: Moving a table from the file restore to the live database (click to enlarge)

Once you've dropped the file into the target, you'll see a progress window, as shown in Figure 15.

Figure 15: Copy Progress (click to enlarge)

3. When the copy progress has finished, you have restored your data and can now click Close.

Figure 16: Copy Progress Finished (click to enlarge)

Additional Resources

Was this article helpful?

1 out of 1 found this helpful

You must sign in before voting on this article.

Want to talk about it? Have a feature request?

Head on over to our Datto Community Forum or the Datto Community Online.

For more Business Management resources, see the Datto RMM Online Help and the Autotask PSA Online Help .

Still have questions? Get live help.

Datto Homepage