0

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

  • Can you check and post the error message of the job step? – Stijn Wynants Feb 14 '17 at 8:01
  • @StijnWynants When i check the history on the server, that is the only error message that is why it's hard for me to troubleshoot. – japzdivino Feb 14 '17 at 8:08
  • Is there anything in your errorlog? – Stijn Wynants Feb 14 '17 at 8:10
  • Here is the event log on server: DATABASE01-Trans1PM.Subplan_1 0xAC8F7C6D2BFC5444AC7F8C12CB90B894 Failed 2017-02-14 13:00:00 The job failed. The Job was invoked by Schedule 1012 DATABASE01-Trans1PM.Subplan_1). The last step to run was step 1 (Subplan_1). – japzdivino Feb 14 '17 at 8:16
  • I mean the errorlog of your SQL Server check for any message at 2017-02-14 13:00:00 – Stijn Wynants Feb 14 '17 at 8:23
1

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

  • Thank you so much @Scott, this solves my problem you're great! :) – japzdivino Feb 17 '17 at 1:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.