When running the backup manually by pressing the green “Run now” button, it runs fine. However, scheduling it to run 5 minutes later via scheduled job, it fails. Application hasn’t been closed between running the manual job and scheduled one.
Log:
1/16/2019 9:25 AM Starting scheduled job “DNEVNI” - “Full”. Computer “TRAKTOR”. App v.“12.1.3”
1/16/2019 9:25 AM Connecting to SQL Server: 2005 SP4 Express Edition. .\SQLEXPRESS
1/16/2019 9:25 AM The backup folder “C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Backup” has “404.751GB” free space. The temporary folder “C:\Users\Traktor\AppData\Local\Temp\Pranas.NET\SQLBackupAndFTP\backup” has “404.751GB” free space
1/16/2019 9:25 AM Backing up “.\SQLEXPRESS” SQL Server databases
1/16/2019 9:25 AM Getting maximum file size…
1/16/2019 9:25 AM The maximum file size: “4882.813GB”
1/16/2019 9:25 AM Failed to backup “GamaBase” database with “Full” backup type: One or more errors occurred. > Access to the path ‘C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Backup’ is denied.
1/16/2019 9:25 AM Failed to backup “GamaAccounts” database with “Full” backup type: One or more errors occurred. > Access to the path ‘C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Backup’ is denied.
1/16/2019 9:25 AM Cleaning up backups of “DNEVNI” job
1/16/2019 9:25 AM Job “DNEVNI” finished with “2” errors
1/16/2019 9:25 AM Sending job log to REDACTED
1/16/2019 9:25 AM Sending job log to REDACTED
1/16/2019 9:25 AM Sending report to ${https://sqlbackupandftp.com/weblog?jobid=2d6038a0-839a-4362-a990-37b449b2becb|Web Log}
Any ideas?
