This article explains the process to perform a granular Microsoft SQL database restore using Ontrack PowerControls for Microsoft SQL Server. 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).
- Datto SIRIS
- Datto ALTO
- Microsoft SQL Server
The restore process has several steps:
- Download Ontrack for SQL
- Check the Microsoft SQL Server datastore
- Mount a file restore
- Use Ontrack to connect the data source and SQL target
- Copy source target
Here is a video that shows an overview of the process:
1. Download Ontrack for SQL
1. Download and install Ontrack PowerControls for Microsoft SQL Server on a Windows PC that can connect to the Microsoft SQL Server.
2. Log into the web interface for your Datto appliance. Go to the Advanced menu, and click Granular Restore. Click to download the Executable and the License File.
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.
2. 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.
2. In the Server Properties window, click the Database Settings option, as shown in Figure 3.
Note the location of the Data and Log files. You will need this information later.
3. Mount a file restore
1. To start the file restore, click the Restore tab of the Datto appliance. You will see the restore page, as shown in Figure 4.
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. You will see the mount recovery point screen, as shown in Figure 5.
4. Click the Mount button, and you will see the Samba share information, as shown in Figure 6.
4. Use Ontrack to connect the data source and SQL Target
1. In the Ontrack program, go to the File menu and click Open Source.
2. Navigate to the data source, choose the *.mdf file, and click Open.
3. You will see the Data Wizard window, as shown in Figure 9. Click the Add... button.
Add the log (*.ldf) file, as shown in Figure 10.
4. You will see the Data Wizard with both the *.MDF and *.LDF files listed, as shown in Figure 11.
5. Click the Finish button, and you will see a progress window, as shown in Figure 12.
5. 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.
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 restore to the DattoDummyDataSQL live database.
Once you've dropped the file into the target, you'll see a progress window, as shown in Figure 15.
3. When the copy progress has finished, you will see a window, as shown in Figure 16. You have restored your data and can now click Close.