MSP360 News
Articles, guides, whitepapers and other useful content for MSPs and IT Professionals
SQL Server Database Restore

SQL Server Database Restore with CloudBerry

CloudBerry Backup supports backup and restore of Microsoft SQL Server databases. The product integrates with Microsoft SQL Server's built-in backup and restore mechanisms, provides SQL Server compression, and offers flexible scheduling, among a range of other useful options.

In this article, we’ll discuss how to restore SQL Server databases using CloudBerry’s solution. For instructions on the backup process, please refer to our article “SQL Server Database Backup.”

We assume that you’re already familiar with how SQL Server functions, as this article only covers the way in which CloudBerry’s solution interacts with SQL Server.

You need CloudBerry Backup for MS SQL Server or CloudBerry Backup Ultimate editions to be able to perform SQL Server database restore.

Ensure that your server is up and running and then proceed to CloudBerry Backup.

How to Restore a Database in Microsoft SQL Server

1Run CloudBerry Backup and launch the Restore Wizard.

2Select the cloud location or physical storage from which to restore your backup. Then select whether to Run restore just once or Save restore plan for further runs (and specify the plan name). Click Next.
Specify SQL Server database restore plan name

3On the next wizard page, choose what kind of data you need to restore. To proceed with restoring SQL Server databases, select the corresponding option and click Next.
Selecting data type for SQL Server restore

4Select a version of the data you want to restore. You can choose to restore the Latest version or specify a Point in time. Click Next.
Select latest version or a specific point in time for SQL Server restore

5Select the SQL Server instance, preferred authentication method and login information. Click Next.
Selecting the SQL Server instance for restore plan

6Select the databases you'd like to restore and click Next.
Selecting SQL Server databases for restore

7Choose whether to overwrite the existing databases with their restored versions and specify the names for the restored databases. If on step 3 you’ve chosen to Restore MS SQL Server Database, your databases will be restored to the destinations of their origin. If on step 3 you’ve chosen to Restore MS SQL Server backup files, this step will be skipped.
Specify the names for the restored SQL Server databases
The wizard will not be able to overwrite an existing database unless you check the corresponding checkbox.

8 If on step 3 you’ve chosen to Restore MS SQL Server Database, configure the additional options for the restored database:
ditional options for the restored database:
- Data file folder - specifies the location for MDF files.
- Log file folder - specifies the location for LDF files containing logs.
- File name template - enables you to specify a custom template for naming the restored MDF and LDF files.
You can also choose whether the backup service should close all existing connections to the destination database by enabling the corresponding option on this wizard page.
Configuring additional options for the restored SQL Server databases
If on step 3 you’ve chosen to Restore MS SQL Server backup files, you will have to specify a destination folder for your backups and a backup file template.
Specifying the options for restoring the SQL Server database backup files.
When restoring backup files from multiple databases, you can make the wizard automatically create a separate directory in the destination folder for each of these databases by enabling the corresponding option on this wizard page.

9If your data was encrypted on the client side, check the Decrypt encrypted files with the following password box. Enter your password, re-enter it to confirm and click Next.
Specifying the encryption options for SQL Server restore

10On the next few steps, configure the remaining options: create a schedule for your SQL Server database restore process if needed, customize email notifications, specify system log settings and more.

11Review the details of your MS SQL Server database restore plan and click Next to create it.Reviewing the details of SQL Server database restore plan

12On the last wizard page, specify whether you need to start the restore process after closing the wizard (this option is available if you chose to save the restore plan previously in this wizard), and click Finish.

Your MS SQL Server database restore plan has now been created.