Lesson 4 - Exercise

Document created by RashmiRao on Nov 15, 2019
Version 1Show Document
  • View in full screen mode

Create an initial Baseline backup

Open Command Prompt and Run as Admin. Screenshots below display the commands that were used to create the baseline back and verify that it was successfully completed.


The image below displays that the baseline backup was created successfully



Create Automated Backup

The image below displays that command prompt with commands to create automated backups in F drive.



Check the Task Scheduler to verify that the PI Backup is generated

The Image below displays Task Scheduler and the location and type of the Automated backup





Check the Backup Directory and the Automated folder to see if a log file is generated

The image below displays a log file being generated in the Automated folder



Configure AF Backup


Open SQL server management studio.

The image below displays how the AF backup was configured



The image below displays that the AF backup was successful.



1. Where are the backup files located? 

     The backup files are located on my F Drive and in Backup Folder  (F:\Backup)

2. When and how often are the files backed up?

    Files get backed up every day at 3:15 AM

3. Determine how PI AF Server is backed up? Where are the backed up files stored?

   If AF Server and AF SQL Server are installed on the PI Data Archive, then AF backup is integrated with PI Data Archive backup. The PI backup script automatically calls for the AF backup script that backs up AF SQL DB. The PI        AF Server files are backed up on F Drive - F:\Backup\Automated\AF

4. When and how often are the files backed up?

    This job is scheduled to run every day at 3:15 am.