AnsweredAssumed Answered

Need Help Resolving PI AF Backup Failing

Question asked by rcorywaugh on Nov 9, 2018
Latest reply on Nov 9, 2018 by rcorywaugh

This is just an FYI to other users who may be using the cloud environment for this course. I noticed that when I attempt to run a backup I backup the PI archives, but the AF backup folder was empty. Additionally, the backup task was generating error files. Initially, I thought this was because the PI AF Link was not set up, so I used the wizard in order to configure it. However I am still getting the following errors at the end of the log:

 

------------------------------------------------------------------------------------------------

 

Backup AF data...

 

C:\Windows\system32>SET SQLINSTANCE=.

 

C:\Windows\system32>sqlcmd -S . -d PIFD -Q "EXEC dbo.usp_backup @outpath = N'F:\PIBackups\Automated\AF\';" -E

Sqlcmd: Error: Microsoft SQL Server Native Client 11.0 : Login failed for user 'NT AUTHORITY\SYSTEM'..

Sqlcmd: Error: Microsoft SQL Server Native Client 11.0 : Cannot open database "PIFD" requested by the login. The login failed..

Backup AF data...done.

Fri 11/09/2018 15:08:34.62

No pisitebackup.bat script found. Skipping site-specific backup.

 

Backup completed: Fri 11/09/2018 -- 15:08:34.65 

For additional log messages, please examine the PI Server Message Log.

-------------------------------------

!!!!!PIBACKUP.BAT SCRIPT FAILED!!!!!!

AF Server Backup Status =  1

-------------------------------------

 

---------------------------------------------------------------------------------------------------

 

Any help with this would be appreciated. Thanks in advance!

Outcomes