Step 4. Specify Restore Settings

This step is available only if you have selected the Restore to a new location, or with different settings option at the Account & Restore Mode step of the wizard.

At the Settings step of the wizard, you can specify the following:

• Settings for the SQL server that will host the restored database

• New names for the restored databases

Specifying SQL Server Settings

To specify settings for the SQL server that will host the restored database, do the following:

1. In the Server Settings section, click Edit Server Settings.
2. In the Server settings window, do the following:

1. From the Region drop-down list, select an Azure region where the SQL Server that will host the restored database resides.
2. From the SQL server drop-down list, select the target SQL Server.
3. From the Elastic pool drop-down list, select an elastic pool to which the restored database will be added.

For an elastic pool to be displayed in the list of available pools, it must be created in the Microsoft Azure portal as described in Microsoft Docs.

4. From the SQL account drop-down list, choose an Azure SQL Server account that will be used to authenticate against the target SQL Server.

3. After you specify the SQL server settings, click Save.

Renaming Restored Databases

To specify a new name for each Azure SQL database you want to restore, do the following:

1. In the Database settings section, in the Actions column, click the Edit icon in the row of the database whose name you want to change.
2. In the Rename database window, specify a new name for the database in the New database name field.
3. After you specify a new name for the restored Azure SQL database, click Save.