Good Morning All,
This morning I checked the results of my AF backups and they failed. I am running W2K12R2, hosting PI AF 2016 and Coresight 2016 with SQL Server 2014 Standard Edition. These backups have never completed successfully before, which is fine as it is a new system and I have not finished installation and configuration (but I am getting close). The backup is using the "OSISoft Backup (PIFD)" job.
As prescribed by the PI AF Installation and Upgrade Guide, I made sure to run the job using a credential that had the sysadmin role. I also changed the Recovery Model from Simple to Full, changed the schedule to 1900, specified an output path, and added a parameter, "@alwaysfullbackup = 0". I thought this parameter was necessary based on the guide (see page 205), but I may be mistaken.
So, now here is the command: EXEC [dbo].[usp_backup] @outpath = N'I:\AF\', @alwaysfullbackup = 0 ;
And my error is: Executed as NT SERVICE\SQLSERVERAGENT. @alwaysfullbackup is not a parameter for procedure usp_backup. [SQLSTATE 42000] (Error 8145). The step failed.
What do you recommend?