Use Microsoft SQL to back up and restore the database

Prev Next

To save the Disaster Recovery Snapshot with the ePO - On-prem server configuration information, use Microsoft SQL Server procedures.

To complete this task, you must have connectivity and authorization to copy files between your primary and restore ePO - On-prem SQL Servers.

After you create a Snapshot of the ePO - On-prem server configuration, you must:

  1. Create a Microsoft SQL Server backup of the database using:

    • Microsoft SQL Server Management Studio

    • Microsoft Transact-SQL

    See your Microsoft SQL Server documentation for details to complete these processes.

  2. Copy the backup file created to your restore SQL Server.

  3. Restore the backup of the primary SQL database that includes the Disaster Recovery Snapshot records using:

    • Microsoft SQL Server Management Studio

    • Microsoft Transact-SQL

    See your Microsoft SQL Server documentation for details to complete these processes.

This creates a duplicate SQL Server ready for restoration, if needed, by connecting it to a new ePO - On-prem installation using the Restore option.