Set PIFD database recovery model
- Last UpdatedOct 02, 2024
- 1 minute read
- PI System
- PI Server 2018
- PI Server
Complete the following steps on both the principal and mirror servers.
-
Open Microsoft SQL Server Management Studio, and connect to the SQL Server instance that stores the PI AF SQL Server database (typically named PIFD).
-
Expand Databases, right-click PIFD, and choose Properties.
-
In the Database Properties – PIFD window, select the Options page.
-
Set the Recovery model to Full.
-
Click OK.