Upgrade a PI AF database in a SQL Server availability group

You can upgrade a PI AF database that is in a SQL Server availability group. Before you begin the upgrade procedure, make sure the following items are in place:

• You have the db_owner privilege to upgrade the PI AF SQL Server database.

• You should also notify your PI AF users that the system will be unavailable for a short period of time. When you are ready to initiate the upgrade, and you are sure all transactions have completed, stop the PI AF Application Service on the PI AF application server machine.

1. Run the PI Server install kit on the SQL Server machine that is the primary replica of the availability group; select only the AF SQL database scripts and AF SQL script execution options. If you are prompted to enter the PI AF server machine name, you can leave it blank.

   When the upgrade is complete on the primary replica, the data and schema updates will be automatically replicated to the databases on the secondary replica machines.

2. To update the PI AF SQL scripts that were placed on the secondary machines during installation, run the PI Server install kit on each of the secondary replica machines in the availability group; select only the AF SQL database scripts option without the AF SQL script execution options. It is unnecessary to provide the SQL Server name or validate the SQL Server connection. It is also unnecessary to enter the PI AF server machine name, if prompted.

3. Run the PI Server install kit on the PI AF Application Service machine to upgrade the PI AF application server.

4. Verify that the PI AF Application Service is running under the correct domain account.

5. Start the PI AF Application Service.

The upgrade of the PI AF database in the availability group is now complete.