This article provides information about the Phoenix agent configuration details and logs for an MS-SQL server setup.
Phoenix agent log files
The Phoenix agent log files contain details of backups that the Phoenix agent performs. After every backup, Phoenix creates a new log file in the Phoenix<YYYY/MM/DD>-<timestamp>.log format. If Phoenix agent does not function as expected, you can share these log files with the Druva Support team.
Note: Phoenix retains logs for the last 32 agent activities on each server.
On all versions and editions of an MS-SQL server, you can find the logs at C:\ProgramData\Phoenix\FS\logs. The free space at this location should be at least 1% of your source data size.
Note: After each backup and restore, Phoenix performs a rollover of the accompanying logs. If you encounter an error during a backup or restore, check the log file for errors at the time of the backup or restore operation.
In addition to the Phoenix logs, you can also find the following logs on your MS-SQL servers:
- Phoenix creates Windows Event Viewer logs with a .evt location. To know how to manage these logs, see this article in the Microsoft library. If you encounter errors during backup or restore, look for errors with source = ‘VSS’, ‘MSSQLSERVER’, or ‘SQLVDI’.
- The MS-SQL server logs. To know more, read this article describing the MS-SQL server logs.
Phoenix agent configuration details
The Phoenix.cfg file contains the configuration details that Phoenix agents require to communicate with Phoenix Master.
Note: We recommend that you do not modify Phoenix.cfg except when required. In scenarios where you must modify these configuration files, contact the Druva Support team for assistance.
You can find the Phoenix agent configuration details at the following locations:
- Windows 2012 Server
- Windows 2008 Server
- Windows 2003 Server
C:\Documents and Settings\All Users\Application Data\Phoenix\FS
Phoenix agent services
On Windows servers, Phoenix Agent Client Service manages backups and restores. The PhoenixCPH service on Windows servers ensures that the Phoenix Agent Client Service is running.
Note: If Phoenix agent stops working, PhoenixCPH (Windows) starts Phoenix agent.
Phoenix agent metadata
When you install Phoenix agents on your servers, Phoenix creates the following metadata folders in the Phoenix folder:
- The logs folder
This folder contains logs for backup and restore jobs for MS-SQL server.
- The state folder
This folder contains metadata that optimizes restores.
- The stats folder
This folder contains metadata that optimizes backups.
Note: The logs folder contains three folders Backup, Restore, and Upload, respectively. Each of these folder contains <backupset_id> folders. The string <backupset_id> represents the unique identification number of the backup set configured on the server.
On MS-SQL servers, the metadata folders are created at C:\ProgramData\Phoenix\SQL.
At the time of restore, Phoenix creates a database_files.txt file at <Drive>\restore\<snapshot>\<Request ID>. This file contains details of how the database files are mapped to the database, and how the database is mapped to its instance in a Unicode format. You require this file to manually attach the database to an instance at the time of restoring to a different server.