When you are going to save backups on any storage destination (on a local storage or on a cloud service), the first questions most likely are “How long should I keep backups here and how can I specify backup’s lifetime in SQLBackupAndFTP?” More…
Cannot perform the requested operation on an item that does not exist. Type: Xceed.FileSystem.DiskFile
If you run a backup job manually, it successfully work, however, when it runs as a scheduled job it fails with the error message: “Cannot perform the requested operation on an item that does not exist. Type: Xceed.FileSystem.DiskFile”, you can around this issue with one of the below solutions.
- Open the backup job with SQLBackupAndFTP software and setup a temporary folder for the job, for example C:\Temp. You can find this option at “Advanced Settings” window.
- Schedule the job with your credentials using “Run scheduled job as” option at “Advanced Backup Schedule” window.
The server principal “NT AUTHORITY\SYSTEM” is not able to access the database “database-name” under the current security context
If you encounter the error message: “The server principal “NT AUTHORITY\SYSTEM” is not able to access the database database-name under the current security context”, you will find the solution below:
Go to the “SQL Server” sections and click on gear button. At the opened “Connect to SQL Server on this computer” window you need select “Windows Authentication” and enter User Name and Password. Press “Test SQL Server Connection” to make sure that you have specified the correct data and then click on “Save & Close” to save and apply new settings.