Phoenix discovers SQL Resources like instances, availability groups (AGs), and associated databases when the Phoenix agent runs a discovery operation. Phoenix runs a discovery operation when:
- A Phoenix agent is activated.
- The Phoenix agent service restarts on the Windows Server host. Phoenix runs discovery only if there is at least a 20-minute gap between two restarts.
- Every 24 hours.
- It is triggered using the Phoenix Management Console and it was not triggered automatically in the last 10 minutes.
- For an AG backup set, you run a backup using the Backup Now button on the Phoenix Management Console.
Note: Phoenix cannot run a discovery on only one node of an AG. For Phoenix to discover databases on an AG, the Phoenix agent should run discovery on at-least two nodes of the AG.
To trigger a SQL discovery manually
- Log in to the Phoenix Management Console.
- On the menu bar, click the drop-down next to All Organizations and select the organization which has your MS-SQL server instances and availability groups.
- On the menu bar, click Protect > MS-SQL Servers.
- From the All SQL Resources page, select or or more instances or availability groups, click more options, and then select Discover Databases. You can click the refresh icon next to Resources to initiate a discovery.
Support for case-insensitive database names
- The discovery of all databases and AG databases is case insensitive.
- Instance databases are all databases excluding AG databases. The discovery of instance databases is case sensitive.
- Server-side mapping is the discovery information that Phoenix stores in its database. The information stored is case-sensitive.