If you have a database in the OFFLINE state and these databases are scheduled to be backed up, their backup will fail and the whole backup job will be shown as Failed. Same when you use Database Mirroring, you may have databases in Restoring state and they can’t be backed up either. If you have such databases included in your backup job, you may want to skip them if they are in an Offline or Restore state and show the whole job as Success, not Failure. Continue reading How to skip databases in Offline state in SQLBackupAndFTP
All posts by Alexey
How to exclude databases from a backup job in SQLBackupAndFTP
SQLBackupAndFTP has an option to backup all non-system databases. This is useful as it would automatically add all the new databases added after the backup job was created. Continue reading How to exclude databases from a backup job in SQLBackupAndFTP
How to specify backup’s lifetime
When you are going to save backups on any storage destination (on 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?” Continue reading How to specify backup’s lifetime
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 works, 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. Continue reading Cannot perform the requested operation on an item that does not exist. Type: Xceed.FileSystem.DiskFile
[DBMS-MSSQL:11006#916] The server principal “NT AUTHORITY\SYSTEM” is not able to access the database under the current security context
If you encounter the error message:
[DBMS-MSSQL:11006#916] 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 the gear button. At the opened “Connect to Server” window you need to select “Microsoft SQ: Server (local) as your Server type, choose “Windows Authentication” and enter User Name and Password. Press “Test Connection” to make sure that you have specified the correct data and then click on “Save & Close” to save and apply new settings. Continue reading [DBMS-MSSQL:11006#916] The server principal “NT AUTHORITY\SYSTEM” is not able to access the database