The procedure to restore an SQL Server database using a wizard is as follows:
Immediately after login, on the Action pane of the Overview screen on the Main tab, click for SQL Server under Restore Wizard.
A list of servers is displayed by selecting Server on the global navigation tab, click for SQL Server under Restore Wizard on the Action pane.
The Welcome to Restore Wizard for SQL Server page is displayed. Check the message displayed in the Information area, and then click Next.
The Select of Database Server page is displayed. From the displayed database servers, select one to be restored, and then click Next.
Information
The servers that meet all the following conditions are displayed on the page:
It is registered on the ETERNUS SF system as a Managed Server of AdvancedCopy Manager.
The version 16.1 or later AdvancedCopy Manager's agent is installed.
The server operating system is Microsoft Windows Server 2008 or later.
The Input of Authentication page is displayed. Enter the following authentication information for the instance of restore target, and then click Next.
Item Name | Specification | Explanation |
|---|---|---|
NetBIOS Domain Name | Optional | Specify a NetBIOS domain name of the database server.
The maximum length of the input character is 15. When this specification has been omitted, the local domain is selected. |
User Name | Required | Specify a user name of the database server. It is necessary to specify a name of the user with all the following authorities:
|
Password | Required | Specify a password for the user name of the database server. |
The Select of Instance page is displayed. Select the instance of restore target, and then click Next.
Information
The instances that meet all the following conditions are displayed on the page:
An instance of SQL Server 2012, SQL Server 2014, or SQL Server 2016 that is installed on the database server selected in step 3
An instance that has successfully been connected using the authentication information entered in step 4
An instance whose service is running
An instance where a default database is set as "master"
Instances on which a database that has been backed up exists
The instance displayed on the page depends on whether the database server selected in step 3 is a physical server or a logical server.
When a physical server has been selected
Only the instances of non-clustered configurations are displayed.
When the physical node of a clustered configuration has been selected, only the instance of that physical node is displayed.
When a logical server has been selected
Instances of clustered configurations are displayed.
The Select of Database page is displayed. Select the following items, and then click Next.
Item Name | Explanation |
|---|---|
Database Name | Select the database to be restored. When an identical volume is being shared by multiple databases, all databases sharing that particular volume are displayed together. Similarly, Restore Method and Backup Date are displayed together. |
Restore Method | Select a restoration method ("Latest time" or "Point of backup") from the drop down list. The "Latest time" can only be selected in cases when all transaction logs generated after the latest backup are in order. |
Backup Date | This is the date that the restore target was backed up. This item can be selected when the Restore Method is "Point of backup". When the database has been backed up in multiple generations, select a backup time of the generation to be restored. |
Information
The databases that meet all the following conditions are displayed on the page:
User databases that existed on the instance selected in step 5
User databases for which a backup has been obtained
With restoration to the latest point, it is checked whether the system is in the following state:
Recovery Model is either "Full" or "Bulk logged".
A bulk operation has not been executed after a full backup in cases when Recovery Model is "Bulk logged".
The log backups from after the latest full backup are in order.
A backup of the latest transaction log has been obtained immediately prior to execution of the Restore Wizard.
Note
Databases in operation are also displayed on the page. Select the correct database to be restored in order to avoid mistakenly restoring a database that is in operation.
If a backup of a transaction log has not been acquired since last full backup, only "Point of backup" can be selected as a restore method.
The Input of Log Backup page is displayed. Enter the following item, and then click Next.
Item Name | Explanation |
|---|---|
Log Backup Path | Specify a backup destination for the transaction log. As a default, the path of the log backup which is configured with SQL Server is displayed. Input is not required in cases when "Point of backup" has been selected for Restore Method in step 6. |
The Checking the restore information page is displayed. The displayed information is as follows:
Restore Method
Database Server
Restore Information
Backup Information
Check the displayed information, and then click Execute.
The confirmation message about the restore processes is displayed in the Confirm dialog box. If no problem about the restore for the displayed database exists, click OK.
The Restore of SQL Server dialog box (dialog box to notify of having accepted restore execution) is displayed. Clicking Done transits to the Main screen or Server Overview screen (returns to the wizard's starting point).
