Granular SQL Restore with Ontrack PowerControls


1. Scope

This article explains the process to perform a granular Microsoft SQL database restore using Ontrack PowerControls for Microsoft SQL Server. These instructions were produced with Ontrack PowerControls v. 8.1 and Microsoft SQL Server 2008. Ontrack PowerControls for SQL 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 Exchange Mailbox Restore with Kroll Ontrack (Kroll Restore).
To perform SQL restores, Datto appliances use Kroll Ontrack PowerControls version 8.1. Newer versions of this software are unsupported.

2. Process

The overall process has several steps:

  • Download Ontrack for SQL
  • Check where your SQL Server stores its data
  • Mount File Restore on Datto
  • Use Ontrack to connect to source and target
  • Copy source to target

Here is a video that shows an overview of the process:

2.1. Download Ontrack for SQL

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

First, log into the web interface for your Datto appliance. Go to the Advanced menu, and click on Granular Restore. Click to download the Executable and the License File.

Figure 1 - Download Ontrack PowerControls for MS SQL Server

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 restore. To learn how to install Kroll OnTrack PowerControls for Microsoft Exchange and SharePoint, see our Exchange article.

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.

2.2. Check the Microsoft SQL Server Datastore

In order 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 on 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

In the Server Properties window, click on the Database Settings option, as shown in Figure 3.

Figure 3 - Database Settings

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

2.3. Start a File Restore

To start the file restore, click on the Restore tab of the Datto appliance. You will see the page as shown in Figure 4.

Figure 4 - Start a Restore

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

Click Start File Restore. You will see the Mount Recovery Point screen as shown in Figure 5.

Figure 5 - Mount Recovery Point

Click the Mount button, and you will see the Samba share information as shown in Figure 6.

Figure 6 - Samba Share information

2.4. Use Ontrack to connect to the data source and SQL Target

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

Figure 7 - Open Source

Navigate to the data source you discovered in Section 2.2., choose the *.mdf file, and click Open.

Figure 8 - Select the data file

You will see the Data Wizard window, as shown in Figure 9.

Figure 9 - Data Wizard

Click the Add... button to add the log (*.ldf) file, as shown in Figure 10.

Figure 10 - Add the *.LDF file

You will see the Data Wizard with both the *.MDF and *.LDF files listed, as shown in Figure 11.

Figure 11 - Source files added

Click the Finish button, and you will see a progress window, as shown in Figure 12.

Figure 12 - Open Source progress

Next, 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

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 restore to the DattoDummyDataSQL live database.

Figure 14 - Moving a table from the file restore to the live database

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

Figure 15 - Copy Progress

When the copy progress has finished, you will see a window as shown in Figure 16. At this point, your data has been restored. You can click Close.

Figure 16 - Copy Progress Finished

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 Community Forum or get live help.

Datto Homepage