database backup strategy

Former Member · ‎07-23-2007

any body please suggest me one standard backup strategy . the platform is ibm aix /db2

thanks

Former Member · ‎07-24-2007

Dear Akhil,

First of all the backup strategy depends on how company wants to maintain its data and log back ups.

One complete Data Back up once in 15 days. offline backup.

Daily incremental online back up of both Data and Log.

Log backup can be save and delete form.

This will help you point in time recovery incase you face any crashes.

Thanks & Regards

Vivek

Former Member · ‎07-24-2007

Hello,

Check this..

Backup Strategy

And

And

Yes, basically it depends on the company.

ie it varies company to company.

And before go-live ,

Take DEV daily backup

Qty weekly twice, PRD daily.

After golive,

Take Dev weekly thrice, Qty once in a week, Prd daily.

Note: Points always encourage me to reply !!

Message was edited by:

MSR

Former Member · ‎07-24-2007

Database backup strategy will be depends upon their company strategy. SAP recommends for every 28days to take offline backup.

BRF+ giving dump