AnsweredAssumed Answered

Exercise 4 - error for SQL access while backup of AF SQL file PIFD

Question asked by sherif.eisa on Jun 29, 2018
Latest reply on Jul 26, 2018 by sherif.eisa

on the VLE environment station named PISRV1:

while doing backup for AF using data Archive backup as all on same machine, I found that no PIFD file in the backup folder?

 

I used the SQL agent to do the backup as per the way in the video but recived again empty folder and no PIFD.bak file, then I checked the erro in log file and fouond the below:

"

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.

"

Please advise how to mitigate this?

Outcomes