--- title: "Use Microsoft SQL to back up and restore the database" slug: "use-microsoft-sql-to-back-up-and-restore-the-database" tags: ["Product Usage", "ePolicy Orchestrator – On-prem", "ePO 5.10.x", "ePO 5.10.0"] updated: 2026-09-07T17:46:02Z published: 2026-09-07T17:46:02Z canonical: "docs.trellix.com/use-microsoft-sql-to-back-up-and-restore-the-database" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.trellix.com/llms.txt > Use this file to discover all available pages before exploring further. # Use Microsoft SQL to back up and restore the database 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.