Restoring an SQL Server instance

With R‑Cloud, you can restore an entire SQL Server instance—all SQL Server databases and the SQL Server instance configuration.

Prerequisite

For improved restore performance, make sure the startup type of the Microsoft iSCSI Initiator Service is not set to Disabled.

Limitation

The entire SQL Server instance can be restored only to the original SQL Server instance.

Considerations

  • You cannot perform a restore of an SQL Server instance if the status of the virtual machine instance or the applications that are hosted on it is Protected deleted.

  • You cannot perform a restore of an application whose retention period specified in the policy has been exceeded (such restore points are grayed out in the R‑Cloud web user interface).

Procedure

  1. In the Applications panel, click the SQL Server application whose instance you want to restore to open the Detail view.

    Note  The Detail view appears only if you click an application. Selecting the check box before the name of the application does not open the Detail view.

  2. In the Detail view that appears at the bottom of the screen, select the preferred restore point.

  3. Click Restore Files Restore.

  4. Select Restore MS SQL Instance, and then click Next.

  5. From the Restore From drop-down menu, select which tier you want to use for the restore. Your restore point can contain one or more tiers among which you can select:

    • Automatic: This option ensures the fastest and most cost-effective restore.

    • Backup (Snapshot)

    • Backup (Target)

    • Copy

    • Archive—(daily, weekly, monthly, yearly)

    Note  The databases that belong to the SQL Server instance are listed under Databases. You can search for a database by entering its name in the Search field and then pressing Enter.

  6. Click Next.

  7. Depending on whether you want to recover the SQL Server instance or to leave the instance in the open mode after the restore, select one of the following options, click Next, and then follow the instructions:

    Option Instructions
    Recover

    The Overwrite existing databases option is enabled by default and you cannot disable it. All the databases that belong to the SQL Server instance will be overwritten.
    Leave in Open Mode

    The Overwrite existing databases option is enabled by default and you cannot disable it. All the databases that belong to the SQL Server instance will be overwritten.

    Important  After leaving the SQL Server instance in the open mode, you must apply transaction logs to the databases after the restore, which allows you to recover the instance to a specific point-in-time. For instructions, see SQL Server documentation.
  8. Click Restore.