How to skip databases in Offline state in SQLBackupAndFTP
If you have a database in the OFFLINE state and these databases are scheduled to be backed up, their backup will fail […]
Author: 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 […]
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 […]
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 […]
[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 […]