on 06-09-2011 2:04 PM
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.
You should be able to get all the MS-SQL server related docs under http://www.sdn.sap.com/irj/sdn/mss
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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ú
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.