Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ PI Server Installation and Configuration (PI Server 2024 R2)

TABLE OF CONTENTS

Migrate an existing PI AF database

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
  • Last UpdatedOct 03, 2024
  • 1 minute read

You can migrate the PI AF SQL Server database from a standalone PI AF deployment to your SQL Server availability group.

  1. Perform a backup of the PI AF SQL Server database from your standalone SQL Server. See Run the PIFD database backup.

  2. Perform a restore of this backup PI AF SQL Server database onto the principal machine in the AlwaysOn Availability group. See Add a PI AF database.

  3. Manually execute the SQL scripts on the restored PI AF SQL Server database to create the SQL Agent Jobs on the principal machine in the AlwaysOn Availability group. See Manual creation of the PI AF SQL Server database.

  4. Perform a new backup of the PI AF SQL Server database created.

  5. Restore this new PI AF SQL Server database backup onto each of the machines in the AlwaysOn Availability group.

TitleResults for “How to create a CRG?”Also Available in