AvePoint Learn
Request article
Contact support
Request article
Contact support
English

    Home > Restore and Recover Your Data > SQL Server

    Export to PDF

    SQL Server

    SQL Server (Microsoft SQL Server in Azure VM and Self-managed SQL Server) restore service supports restoring SQL Server databases to the original location with the CAP Gateway mode.

    In the SQL Server service, Self-managed SQL Server refers to SQL Servers that you install, configure, maintain, and operate yourself, whether they are deployed in the cloud or on premises.

    • Self-managed SQL Server on cloud – The SQL Servers running on virtual machines in cloud platforms such as Azure, AWS, or GCP. While the cloud provider manages the underlying infrastructure, you are responsible for managing the SQL Servers yourself.

    • Self-Managed SQL Server on premises – The SQL Servers installed and operated on local virtual machines in your on-premises environment.

    NOTE

    The Microsoft SQL Server on Azure VM must be version 2022 or later, and self‑managed SQL Server must be version 2016 or later.

    To restore the 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. You choose whether to display the finished with the exception jobs 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 how you would like to restore the data, select a gateway from the drop-down list, and provide an optional description for further reference.

      • Replace the existing database – 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.

        The Database step.

    8. Click Next.

    9. 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.

    10. Click Restore to run the restore job.