Return
-
Title
Can the Database Growth Reports continue to show data for a database in a availability group after a fail over? -
Description
Can the Database Growth Reports continue to show data for a database in a availability group after a fail over? -
Resolution
If you sets the readable secondary option in SSMS, no matter if you pick the primary or secondary replica nodes in the Database Growth Report, it will show the correct data.1. Form SSMS connect to the availability group server2. Open the Availability Group Properties3. From the properties window, under the Availability Replicas options, change Readable Secondary to "yes"