SQL Server Job Failed – The Job Failed. The Job Was Invoked by Schedule 1012

backupsql-server-2012sql-server-agent

I am new on maintaining database backups, i have problem on my scheduled transaction logs, it was working before until i encountered the error below.

Message:

The job failed. The Job was invoked by Schedule 1012 (DATABASE01-Trans1PM.Subplan_1). The last step to run was step 1 (Subplan_1).

The job was supposed to run at exactly 1pm daily, it is working before until i noticed that it's been 6 days since the same error occurs and the backup job was not successful.

Anyone have an idea on that kind of error message ?

Thank you in advance.

Regards

Best Answer

Since you indicated your 'transaction log' backup maintenance plan had been working, but was now failing, double check to make sure none of the databases involved in the maintenance plan have somehow gotten changed to SIMPLE recovery - transaction logs cannot be backed up in SIMPLE recovery mode.

Run this query to identify the recovery mode of all of your databaes.

select name,recovery_model_desc from sys.databases

To begin taking transaction log backups again, you'll need to re-establish the log chain by taking at least a DIFFERENTIAL backup (although, to keep things nice and clean, I'd recommend a new FULL backup) to bridge the gap between the time the database was changed to SIMPLE and now.

For more information about the transaction log and SIMPLE recovery, please check out these links:

Backup Under the Simple Recovery Model

Transaction Log Truncation

Related Question