SAP FORUM: Review DB12 on Manual Check

After some little investigation, I found some different opinion about how to handle manual check or SSM, I think this is because we have shift working on our daily operation. Base on that reason, I want to review about our daily operational with this forum.

Please answer and reply this email by your knowledge about any issue we founded, and we will start with Manual Checking until we found same perception about how to handle every event.

DB12:
Below is result from Database backup (SQL Server database) DB12 manual check. We check this on Monday 19/03/2007.

The question is:

1. Are below result is success or not

Last Successful Backups:
Full R/3 backup 16 Mar 2007 04:13:15
Full master backup 15 Mar 2007 23:49:54
Full MSDB backup 15 Mar 2007 23:49:44

Last Successful Backups:
Full R/3 Backup 15 Mar 2007 23:06:06
Full Master Backup 15 Mar 2007 20:45:43
Full MSDB Backup 15 Mar 2007 20:45:29

2. How about this

Last successful backups:
Full R/3 backup 14 Mar 2007 23:43:20
Transaction log backup 15 Mar 2007 12:16:48
Full master backup 14 Mar 2007 23:43:26
Full MSDB backup 14 Mar 2007 23:43:38

-------------------------Answer-----------------------------

I’ll try to answer based on my knowledge (and of course SOP too)...

1. Are below result is success or not

Last Successful Backups:
Full R/3 backup 16 Mar 2007 04:13:15 (Friday Morning)
Full master backup 15 Mar 2007 23:49:54 (Thursday night)
Full MSDB backup 15 Mar 2007 23:49:44

Last Successful Backups:
Full R/3 Backup 15 Mar 2007 23:06:06 (Thursday night)
Full Master Backup 15 Mar 2007 20:45:43 (Thursday night)
Full MSDB Backup 15 Mar 2007 20:45:29 (Thursday night)

Success!!

Taken from SOP “If last successful backups to today-morning or yesterday-night, except for Monday check which OK if last successful backup on Thursday night, Friday Morning/Night."

2. How about this

Last successful backups:
Full R/3 backup 14 Mar 2007 23:43:20
Transaction log backup 15 Mar 2007 12:16:48
Full master backup 14 Mar 2007 23:43:26
Full MSDB backup 14 Mar 2007 23:43:38

Unsuccessful!!

Because that result happen on Wednesday night and Thursday Morning. If we have assumption that this perform on Thursday 15^th, it’s successful.

-------------------------Answer-----------------------------

OK, I’ll try to answer this question too, from my opinion the backup is not success because, for point off number one :

1. Are below result is success or not

Last Successful Backups:
Full R/3 backup 16 Mar 2007 04:13:15 (Friday Morning)
Full master backup 15 Mar 2007 23:49:54 (Thursday night)
Full MSDB backup 15 Mar 2007 23:49:44

Last Successful Backups:
Full R/3 Backup 15 Mar 2007 23:06:06 (Thursday night)
Full Master Backup 15 Mar 2007 20:45:43 (Thursday night)
Full MSDB Backup 15 Mar 2007 20:45:29 (Thursday night)

Unsuccessfull !!

The backup is finish on date 16 Mar 2007 04:13:15 (Friday Morning), and because we check on Monday

it’s should be finish on Sunday night or Monday morning, and when I take a look on the backup history looks like the backup is running (schedule) every day see the picture below:

So the backup should be finish every day (today-morning or yesterday-night).

And for the point number 2 this is definitely Unsuccessfull if we check on Monday 19-03-2007.

2. How about this

Last successful backups:
Full R/3 backup 14 Mar 2007 23:43:20
Transaction log backup 15 Mar 2007 12:16:48
Full master backup 14 Mar 2007 23:43:26
Full MSDB backup 14 Mar 2007 23:43:38

OK that’s all Thank you, and correct if I’m wrong ....

-------------------------Answer-----------------------------

You are true if your reason base on the sop, but I think there is need little correction to the SOP.

The reason is: I agree with F**y, if we check backup on Monday, the result show from Friday night until Monday morning is success backup. So if the result is Thursday night it should be failed backup. And the rights answer for question 1: Backup Failed

-------------------------Answer-----------------------------

Regarding the backup issue, these are some of the concepts:

· If the Backup was scheduled Daily, it means that on today’s backup check, we are check whether yesterday’s backup end with success or not. And because it’s run daily for Master, MSDB, and Full R/3, it means that for today’s backup check will be successful when on DB12 check said that the date of last successful backup is Yesterday Night (> 18.00) or today morning, except for Monday check, because what we check is backup for Friday, so it will be stated as successful backup when on DB12 said Last successful backup on : Friday Night (>18:00) or Monday morning or in time between Friday night and Monday Morning (it can be Saturday or Sunday).

So, according to the concept, point 1 was not success and need to be reported (also ticket if necessary). While for the SOP, it needs to be adjusted.

· For Transaction backup: we have to check whether it was set on or off, by run transaction DB02 and if we find the recovery mode was simple, it means that the Transaction log is set to off, further, it means that the transaction log backup is not necessary to be checked, but the other backup (Master, Full R/3 and MSDB) still need to be checked. One important thing here: if you found on Production system the transaction log backup was set off (Transaction log is not success), please reported this as an issue.

· Backup should not running inside office hours, so if you find backup running during the office hours (HOLLAND OFFICE HOURS) please report this as an issue, and also ticket if necessary.

· When you find backup is not successful on Manual check, please also check on SSM, and add the info about backup there (check whether backup is currently running or not, and so on).

For point 2, it’s already obvious according the concept.