Phoenix supports backup and restore of databases created and managed using MS-SQL server. On a system, you can have one SQL Server instance or multiple SQL server instances, and each instance can have multiple databases. Phoenix lets you backup and restore databases across systems and instances. Irrespective of the number of instances on a system:
- Phoenix treats that system as a single server, and
- Using Phoenix Management Console, you can execute backup and restore operations for databases that are created and managed on different instances on the server.
You can register multiple servers across geographies. Phoenix can perform following backup and restore jobs for databases:
- Full backups
- Differential backups
- Log backups
- Snapshot restores using full and differential backups
- Point-in-time restores using log backups
After you configure Phoenix for your servers, it performs an ever incremental backup after applying deduplication. For more information, see Key Concepts and Terms.
Phoenix components for SQL servers are briefly described below:
- Phoenix Management Console – Phoenix Management Console is a web-based, unified console that provides complete visibility and high level understanding of the health and status of servers that you have registered. You can globally view and configure servers for backup, restore, and archival of databases. It provides Phoenix administrators ability to:
- Register and configure servers to backup databases in their organization’s server infrastructure.
- Control Phoenix activities by defining policy for backup schedule and retention.
- Monitor backup and restore jobs, activities, and view reports.
- Phoenix Cloud - The server side component of the Phoenix Cloud.
- Phoenix Agent – Phoenix agent is installed on the server which hosts your SQL instances. Phoenix agent is used for:
- Registering and activating a server
- Executing backup database jobs
- Executing restore database jobs
- Collecting SQL Server information such as instances running on a server, and databases within each instance, 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.
- System requirements
- Quick steps to set up Phoenix to back up databases
- Backup methods available for MS-SQL server databases
To know more about full, differential, and log backups for MS-SQL servers, see Microsoft documentation: