The following restore functions are provided by the Backup Manager:
- List databases in recovery point.
- Restore one, several, or all databases.
- Database restore to original or alternate database name/path. See also: [Restore an MS SQL Server to an alternate location].
{info:title=Tip}As an alternative to using the Databases Add-on, you can restore a database's MDF and LDF files using the File Restore function, and then issuing an "Attach Database" query.{info}
You can restore an MS SQL Server database(s) by following the instructions described below in your Server Backup Manager.
1. In the Main Menu, click *Protected Machines*. On the _Protected Machines_ screen, click the _Actions_ icon for a corresponding protected machine and select *Open Recovery Points*.
The _Recovery Points_ window displays.
2. In the _Recovery Points_ window, find the recovery point containing the necessary database replication, click the corresponding _Actions_ icon, and select *Browse Databases*.
The Browse Databases window displays.
3. Select a database instance from the drop-down menu.
!Browse Databases window_Instance outlined_English.png!
4. You can browse the instance by clicking the "+" icon.
!Browse Databases window_plus sign_English.png!
5. Select the database you want to restore and click "Restore Selected."
!Browse Databases window_1 DB checked_Restore Selected button_English.png!
{note:title=Notice}
The system databases {{master}}, {{msdb}}, {{model}}, and {{tempdb}} are not displayed in the "Restore Databases" wizard. To restore these databases, use the [Perform a bare-metal restore|ServerBackup:Perform a bare-metal restore] function.{note}
{info:title=Tip}To be able to restore to an alternate database, do not check the "Databases" box. Instead, select the required databases by clicking the check-box next to each database you want to restore. See also: [Restoring an MS SQL Server to an alternate location|ServerBackup:Restore an MS SQL Server to an alternate location].{info}
6. In the displayed "Restore Databases" wizard window, define the options for the restore.
When restoring SQL Server databases, you have two options for selecting the host to restore to:
* *Restore to Original Host* \- Restoring to the original host will connect to the host name and the port configured when the Recovery Point was created.
* *Restore to Alternate Agent* \- Restoring to an alternate Agent will connect to the selected Agent's host name and the specified port. See [Restore an MS SQL Server to an alternate location].
In our example, we selected the "Restore to Original Host" option.
!sql09.png!
Select an option and click "Next" to proceed to the following step.
!Restore Databases window_Next button_English.png!
7. On the "Alternate DB Names" screen, you may optionally define an alternate database name for any of the selected databases for restore as a new step in the DB restore wizard. If a DB with the new name already exists, that DB restore will fail and will alert the policy.
{newversion} Expand details to select alternate database paths.
{newversion}
!Restore Databases window_Alternate DB Name_English.png!
Click the "Settings" button to specify an Alternate Settings.
!Restore Databases window_Alternate DB Name_Settings button_shortened_English.png!
{info:title=Note}
The "Settings" button is not available if you previously checked the "Databases" check-box. In this case click the "Next" button and go to the [8 paragraph|#summary] below.
!Browse Databases window_All DB checked_English.png!
{info}
The "Alternative Settings" window will be opened.
!Alternate Settings window_English.png!
In the "Alternative Settings" window specify the following options:
* *Use Alternative Settings* \- check this check-box to enable an Alternate Settings.
!Alternate Settings window_Use Alternate Settings checked_shortened_English.png!
{info:title=Note}
Once the "Use Alternative Settings" option has been checked, the Alternative Database Name and Paths should be obligatory entered. Otherwise the warning message will appear.
{info}
* *Alternative Database Name* \- enter a different name for a database you want to restore.
!Alternate Settings window_Alternate DB name entered_shortened_English.png!
{info:title=Tip}
Do not provide extension for a database name.{info}
* *Alternate Database Paths* \- enter a different location for a database you want to restore.
!Alternate Settings window_Alternate Paths entered_shortened_English.png!
{info:title=Note}
Make sure the existent and absolute Paths has been entered. Otherwise the warning message will appear.
{info}
{newversion} The database can be restored to a different location with a different name. If you want to restore to an alternate location, make sure that you provide the alternate database name and the alternate {{.mdf}} and {{.ldf}} file paths.
{newversion}
{info:title=Tip}
When performing an MS SQL Server restore to an alternate directory, the directory must already exist. Create an alternate restore directory before restoring the MS SQL Server to it.
Read more in [ServerBackup:Restore an MS SQL Server to an alternate location].
{info}
{info:title=Note}
If you want to restore to the original location, do not provide any of the above information.
{info}
Once the "Alternate Settings" has been specified, the special green mark will appear in the "Use Alternate Settings" column.
!Restore Databases window_Alternate DB Name_Alternate Settings specified_shortened_English.png!
Click "Next" to proceed to the following step.
!Restore Databases window_Next button_English.png!
{anchor:summary}
8. On the last "Summary" screen, the settings you have selected are listed.
!sql11.png!
9. Once you have verified that the specified settings are correct, click "Restore." The restore process will start immediately.
!Restore Databases window_Restore button_English.png!
10. The "Details for Database Restore" window will appear. It indicates that the restore process has been launched. You can watch the progress in real time.
!sql12.png!
{excerpt:hidden=true}Instructions on how to restore an MS SQL Server database to the original location with Server Backup Manager.{excerpt}
- List databases in recovery point.
- Restore one, several, or all databases.
- Database restore to original or alternate database name/path. See also: [Restore an MS SQL Server to an alternate location].
{info:title=Tip}As an alternative to using the Databases Add-on, you can restore a database's MDF and LDF files using the File Restore function, and then issuing an "Attach Database" query.{info}
You can restore an MS SQL Server database(s) by following the instructions described below in your Server Backup Manager.
1. In the Main Menu, click *Protected Machines*. On the _Protected Machines_ screen, click the _Actions_ icon for a corresponding protected machine and select *Open Recovery Points*.
The _Recovery Points_ window displays.
2. In the _Recovery Points_ window, find the recovery point containing the necessary database replication, click the corresponding _Actions_ icon, and select *Browse Databases*.
The Browse Databases window displays.
3. Select a database instance from the drop-down menu.
!Browse Databases window_Instance outlined_English.png!
4. You can browse the instance by clicking the "+" icon.
!Browse Databases window_plus sign_English.png!
5. Select the database you want to restore and click "Restore Selected."
!Browse Databases window_1 DB checked_Restore Selected button_English.png!
{note:title=Notice}
The system databases {{master}}, {{msdb}}, {{model}}, and {{tempdb}} are not displayed in the "Restore Databases" wizard. To restore these databases, use the [Perform a bare-metal restore|ServerBackup:Perform a bare-metal restore] function.{note}
{info:title=Tip}To be able to restore to an alternate database, do not check the "Databases" box. Instead, select the required databases by clicking the check-box next to each database you want to restore. See also: [Restoring an MS SQL Server to an alternate location|ServerBackup:Restore an MS SQL Server to an alternate location].{info}
6. In the displayed "Restore Databases" wizard window, define the options for the restore.
When restoring SQL Server databases, you have two options for selecting the host to restore to:
* *Restore to Original Host* \- Restoring to the original host will connect to the host name and the port configured when the Recovery Point was created.
* *Restore to Alternate Agent* \- Restoring to an alternate Agent will connect to the selected Agent's host name and the specified port. See [Restore an MS SQL Server to an alternate location].
In our example, we selected the "Restore to Original Host" option.
!sql09.png!
Select an option and click "Next" to proceed to the following step.
!Restore Databases window_Next button_English.png!
7. On the "Alternate DB Names" screen, you may optionally define an alternate database name for any of the selected databases for restore as a new step in the DB restore wizard. If a DB with the new name already exists, that DB restore will fail and will alert the policy.
{newversion} Expand details to select alternate database paths.
{newversion}
!Restore Databases window_Alternate DB Name_English.png!
Click the "Settings" button to specify an Alternate Settings.
!Restore Databases window_Alternate DB Name_Settings button_shortened_English.png!
{info:title=Note}
The "Settings" button is not available if you previously checked the "Databases" check-box. In this case click the "Next" button and go to the [8 paragraph|#summary] below.
!Browse Databases window_All DB checked_English.png!
{info}
The "Alternative Settings" window will be opened.
!Alternate Settings window_English.png!
In the "Alternative Settings" window specify the following options:
* *Use Alternative Settings* \- check this check-box to enable an Alternate Settings.
!Alternate Settings window_Use Alternate Settings checked_shortened_English.png!
{info:title=Note}
Once the "Use Alternative Settings" option has been checked, the Alternative Database Name and Paths should be obligatory entered. Otherwise the warning message will appear.
{info}
* *Alternative Database Name* \- enter a different name for a database you want to restore.
!Alternate Settings window_Alternate DB name entered_shortened_English.png!
{info:title=Tip}
Do not provide extension for a database name.{info}
* *Alternate Database Paths* \- enter a different location for a database you want to restore.
!Alternate Settings window_Alternate Paths entered_shortened_English.png!
{info:title=Note}
Make sure the existent and absolute Paths has been entered. Otherwise the warning message will appear.
{info}
{newversion} The database can be restored to a different location with a different name. If you want to restore to an alternate location, make sure that you provide the alternate database name and the alternate {{.mdf}} and {{.ldf}} file paths.
{newversion}
{info:title=Tip}
When performing an MS SQL Server restore to an alternate directory, the directory must already exist. Create an alternate restore directory before restoring the MS SQL Server to it.
Read more in [ServerBackup:Restore an MS SQL Server to an alternate location].
{info}
{info:title=Note}
If you want to restore to the original location, do not provide any of the above information.
{info}
Once the "Alternate Settings" has been specified, the special green mark will appear in the "Use Alternate Settings" column.
!Restore Databases window_Alternate DB Name_Alternate Settings specified_shortened_English.png!
Click "Next" to proceed to the following step.
!Restore Databases window_Next button_English.png!
{anchor:summary}
8. On the last "Summary" screen, the settings you have selected are listed.
!sql11.png!
9. Once you have verified that the specified settings are correct, click "Restore." The restore process will start immediately.
!Restore Databases window_Restore button_English.png!
10. The "Details for Database Restore" window will appear. It indicates that the restore process has been launched. You can watch the progress in real time.
!sql12.png!
{excerpt:hidden=true}Instructions on how to restore an MS SQL Server database to the original location with Server Backup Manager.{excerpt}