cancel
Showing results for 
Search instead for 
Did you mean: 

Full, log and differential Backup switch to red after one week on DB13

Former Member
0 Kudos

Hello,

I scheduled full, transactional log and differential backup in DB13 calendar. After execution, it's finished successfully, but after two weeks it switch to red. Could you please advise.

My system is SAP CRM 7.0 EHP2 and database is SQL Server 2008R2.

Thank you in advance,

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hello,

Please find below the "Program Log" of log, differential and full backup in DBA calender (database sql server 2008R2)

"No Corresponding SQL Job. Job is deleted in SQLAgent"

Thank you in advance,

Hichem

yakcinar
Active Contributor
0 Kudos

Hello Hichem,

When you schedule a job on DB13, a job scheduled on SQL server Jobs also.

Someone could have been deleted the job on SQL Server.

So delete the scheduled jobs on DB13 and create new ones. This will create a new job on SLQ server also.

This is the solution.

 

Regards,

Yuksel AKCINAR

Former Member
0 Kudos

Hello Yüksel,

Thank you for your feedback. I deleted the history of jobs, it could be the issue but after a moment the job can be deleted by itself?

Thank you,

yakcinar
Active Contributor
0 Kudos

Hello Hichem,

I am not mentioning about the history of the job.

Delete the schedule from the calendar.

And reschedule backup again.

Regards,

Yuksel AKCINAR

Sriram2009
Active Contributor
0 Kudos

Hi

Could you check the over all free disk space in log db? or On SAP use the transaction ST04 check the log used and free space?

Regards

SS

yakcinar
Active Contributor
0 Kudos

Hello Hichem,

Which tool do you use for bacjup?

Are backing up to disk? Can disk be full?

What does logs say on DB13?

Can you check and attach them to this message?

Regards,

Yuksel AKCINAR