I have set up a schedule to do a full backup once a day then differentials every 15 minutes. The full backup ran fine, then diffs ran for a while and had 15 successes, then it stopped working and I get the following:
12:15:01 PM : Starting scheduled job "Backup Job - 1 " - “Differential”. Server “RDS”. Account “administrator@rds”. App v.“12.4.16”.
12:15:01 PM : Connecting to: 2012 SP4 Express Edition (64-bit). .\RDS.
12:15:01 PM : The backup folder “E:\SQL Data\SQL Backup” has “378.249GB” free space. The temporary folder “C:\Users\administrator\AppData\Local\Temp\Pranas.NET\SQLBackupAndFTP\backup” has “141.807GB” free space.
12:15:01 PM : Backing up “.\RDS” SQL Server databases.
12:15:01 PM : WARNING: #[JOB-BAK:2006#11008]. Previous Full backup of “dat” database was created with a different application. (non SQLBackupAndFTP). You may not able to restore the database automatically using SQLBackupAndFTP.
12:15:01 PM : Backing up “dat” database to .bak file. Backup type: “Differential”. Checksum: “Disabled”.
12:15:01 PM : ERROR: Failed to backup “dat” database with “Diff” backup type: One or more errors occurred. > Cannot perform a differential backup for database “dat”, because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option. BACKUP DATABASE is terminating abnormally. > Cannot perform a differential backup for database “dat”, because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option. BACKUP DATABASE is terminating abnormally.
12:15:01 PM : Cleaning up backups of "Backup Job - 1 " job.
12:15:01 PM : ERROR: Job "Backup Job - 1 " finished with “1” errors.
Any ideas what’s going on here?