3 Replies Latest reply on Jul 26, 2018 6:03 PM by sherif.eisa

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

    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?