Configure PI AF SQL Server database backups and restoration

On the principal server computer, make a full backup of the PI AF SQL Server database (typically named PIFD) and a transaction log backup of PIFD.

Place a copy of the two backup files on the mirror server computer.

On the mirror server computer, right-click the PIFD database and select Task > Restore > Database in the backup file to open the Restore Database – PIFD window.

In the Source for restore area, select the From device option.

Click Device to browse to and select the backup file. Return to the Restore Database – PIFD window.

Select the Restore check box for the newly added back-up file in the list of backup sets.

In the Options page:

1. Select the Overwrite the existing database (WITH REPLACE) check box.

2. Select the Recovery State that includes the text: (RESTORE WITH NO RECOVERY).

   The method of selection may vary between versions of SQL Server.

3. Click OK to start the restore operation.

4. When a message opens that indicates the restore operation finished successfully, click OK to return to Microsoft SQL Server Management Studio.

The PIFD database is shown in the Restoring mode.

On the mirror server computer, use the copy of the log file you saved earlier, right-click the PIFD database and select Task > Restore > Transaction Log to open the Restore Transaction Log - PIFD window.

In the Restore Source area, select the From file or tape option.

Click From file or tape to browse to and select the log file. Return to the Restore Transaction Log - PIFD window.

Select the Restore check box for the newly added back-up file in the list of back-up sets.

In the Options page:

1. Click OK to start the restore operation.

2. When a message opens that indicates the restore operation finished successfully, click OK to return to Microsoft SQL Server Management Studio.

The PIFD database is shown in the Restoring mode.