mshashi259 (12/1/2015)
I get the same error message..@backupSetId =...".: 100% complete End Progress Progress: 2015-12-01 03:02:37.21 Source: Back Up Database (Transaction Log) Executing query "BACKUP LOG [DBNAME] TO DISK = N'...".: 50% complete End Progress Progress: 2015-12-01 03:02:38.07 Source: Back Up Database (Transaction Log) Executing query "declare @backupSetId as int select @backupSetId =...".: 100% complete End Progress Progress: 2015-12-01 03:02:38.27 Source: Back Up Database (Transaction Log) Executing query "BACKUP LOG [[DBNAME] ] TO DISK ...".: 50% complete End Progress Progress: 2015-12-01 03:02:39.10 Source: Back Up Database (Transaction Log) Executing query "declare @backupSetId as int select @backupSetId =...".: 100% complete End Progress Error: 2015-12-01 03:02:39.16 Code: 0xC002F210 ... The package execution fa... The step failed.
But, the surprising thing is backups are successful and that is a valid backupset.
What I have changed is in the Maintenance plan of the backup job, I have moved the cleanup job before the Full Or log Backup to happen. I see both the clean up and Full and Log backups are happening just fine but still the job showing as failed.
I did ensure the job steps quits reporting success when ran successfully and Reports failure when failed.
Any suggestions what I can check or how I can get rid of this unnecessary error?
Are you doing the backup to a NAS and is the backup compressed? When the backup starts the NAS allocates an estimated amount of disk space that the file will require. If the compressed file uses less space the NAS has to reset the end of file to the smaller file. This may take longer than the timeout value for the backup. The backup file is good but because the NAS does not respond in a timely manner it thinks it failed when it didn't.