Skip to main content


Druva Documentation

About Phoenix for MS-SQL servers

Phoenix Editions: File:/tick.png Business File:/cross.png Enterprise File:/tick.png Elite


Phoenix supports backup and restore of databases created and managed using MS-SQL server. On a system, you can have one or more MS-SQL server instances, and each instance can have multiple databases. Phoenix lets you back up and restore databases across systems and instances. Additionally, you can back up databases that are part of the SQL Always On Availability Groups (AG). For more information about Microsoft documentation on SQL Always On Availability Groups, see Overview of Always On Availability Groups.

From version 4.7.1, Phoenix agent discovers the stand-alone instances and AGs running on the physical server for backup configuration. The Phoenix Management Console displays the discovered instances and AGs under the Protect >MS-SQL Servers > Instances/AGs tab. You can configure these instances and AGs for backup. 

Phoenix lets you perform the following backup and restore jobs for databases:

Backup-restore methods Standalone instance Availability group

Full backup


  • Supported on the primary node
  • Copy-only on the secondary node
Differential backup tick.png Only on the primary node
Log backups tick.png tick.png
Snapshot restores using full and differential backups tick.png tick.png
Point-in-time and transaction mark restores using log backups tick.png tick.png

After you configure Phoenix to back up databases of the standalone instances and AGs, Phoenix performs an ever incremental backup after applying deduplication. For more information, see Key Concepts and Terms


Phoenix components for MS-SQL servers are briefly described below:

  • Phoenix Management Console: Phoenix Management Console is a web-based, unified console that provides complete visibility and a high-level understanding of the health status of servers that you have registered.  You can globally view and configure instances/AGs for backup, restore, and archival of databases. It provides Phoenix administrators with the ability to:
    • Register and configure instances/AGs to back up databases in their organization’s server infrastructure.
    • Control Phoenix activities by defining the policy for backup schedule and retention.
    • Monitor backup and restore jobs, activities, and view reports.
  • Phoenix Cloud: The server-side component of the Phoenix. 
  • Phoenix agent: Phoenix agent installed on the server, which hosts your MS-SQL instances. Phoenix agent is used for:
    • Registering and activating a server.
    • Executing backup database jobs.
    • Executing restore database jobs.
    • Discovering MS-SQL server information, such as instances and AGs running on a server, and sending this information to the cloud.   
  • Phoenix CloudCache: Phoenix CloudCache is a dedicated server that stores backup data based on its retention settings.  At periodic intervals, Phoenix CloudCache synchronizes this data to Phoenix Cloud relaxing the bandwidth consumption in your infrastructure. 
    For more information, see Phoenix CloudCache.

Related articles

To know more about full, differential, and log backups for MS-SQL servers, see Microsoft documentation:


  • Was this article helpful?