cancel
Showing results for 
Search instead for 
Did you mean: 

Backup Schedule

selvakumar_p
Participant
0 Kudos

Dear Experts,

In my company using application SAP ERP 6.0 EHP4 and database MS SQL server 2008 in Windows server 2008.

We want to schedule the automatic backup.

  • How can schedule backup?*

Kindly guide me for the same.

Thanks and Regards,

Kiruba.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

You should be able to get all the MS-SQL server related docs under http://www.sdn.sap.com/irj/sdn/mss

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi dude!

You can also check SAP notes 1297986 and 1420452 and the referred ones.

As a very very short summary, take into account that transaction DB02 is recommended for the backup scheduling. And specially take into account that whatever the way you run backups, if you want to be able to perform a point-in-time recovery, you need what is called an "online backup"; to be clear, in order to provide a point-in-time recovery you need:

a) to set the SID database in "FULL recovery model"

b) to execute a full database backup regularly (recommended: daily)

c) to execute transaction log backup regularly (recommended: hourly or every 15min, but this depends on your system activity and maximum allowable data loss)

Point c) is crucial for point-in-time recovery. The chain of transaction log (TL) backups must not have any "gaps",otherwise you will not be able to reach the desirable point in time (check note 434645).

Cheers!!

-Jesú