#Restore Self-managed SQL Server Databases

To restore the self-managed SQL Server databases, follow the steps below:

1. Go to the Restore page and click the SQL Server tile.

2. In the Restore wizard, a calendar displays all the data recovery points for managed and self-managed SQL servers. Navigate to the Self-managed tab. You can choose to display jobs that finished with exceptions in the calendar by selecting the Include jobs with only partial backup data option.

3. Hover over the data recovery point to view the job details, including the job status, job start time, scope name, scope ID, job ID, backup size, and the number of objects in a backup.

4. Click the data recovery point that you want to use in the calendar. The databases backed up in the selected backup job are displayed in the table.

5. You can use the search box to search for the databases by name, use the server and instance filters and manage the columns to adjust the view of databases.

6. Select the databases that you want to restore, and then click the Restore button.

7. In the Restore options step, choose where would you like to restore the data, choose how you would like to restore the data, select a gateway from the drop-down list, and provide an optional description for further reference.

   • Where would you like to restore the data? - You can choose to restore the data to the original location or to a new location. To restore the data to its original location, you must note that the database in the original location will be overwritten.

   • How would you like to restore the data - You can choose to replace the existing database or create a new database.

     • Overwrite – The databases in the original location will be overwritten.

     • Create a new database – This option will generate new databases in the original location. Click Next to proceed with configuring of the new database names. In the Database step, you can specify the desired name for each new database by entering it in the New database name column corresponding to each database in the original location.

       

8. Click Next.

9. In the SQL Server connection settings step, configure the SQL server name as required and complete the SQL server authentication settings.

   • Server name - If you restore data to the original location, the server name cannot be modified. If you restore data to another location, you can update the destination server name.

   • SQL server authentication - Review the login name, password, and additional connection parameters. If your SQL server information has changed, update these values as needed.

10. Click Next.

11. Review the restore settings in the Overview step. You can click Back to go back to the previous steps in the restore wizard to modify the settings.

12. Click Restore to run the restore job.