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?