backup

[Former Member]

hi,

how many types of backups.can any one give me the good idea about backup.

Thanku

[Former Member]

Hi,

Please find the following link.

http://help.sap.com/saphelp_erp2005vp/helpdata/en/0d/d300c34a0c11d182b80000e829fbfe/frameset.htm

Regards

Ben

[Former Member]

Hi Kumar,

On a lighter note there are 2 types of back ups...

Ofline ( Where are ur sap users are logged out)

Online ( users can work paralelly on system)

Both these types are from a DB point of view and more ino can be provided on the type of ur DB. Is it Oracle or MS SQL or some other....

preferably a times of 3-5 hours would be an time for huge database backups...

The back up strategies is important and Prod servers need to be backed up every day. It may vary for ur QTY and DEV servers..and more info can be checked from the DB administrators..

Hope it helps...

Br,

Sri

Award points for helpful answers

[Former Member]

Hi,

Thank u for ur replys and i assigned points also.one more thing what is the diffrence between fulldatabase back up and transactional backup.

Thanku

[Former Member]

Hi Kumar,

<b>Full database Backup</b>

A full database backup contains all used data pages and the log files written during the backup. The transaction log is not truncated when you perform a full database backup.

Full database backups may result in a significant amount of disk I/O and should therefore be performed at a time when the workload is low.

You always need a full database backup to restore the database. You cannot restore a differential database backup or a transaction log backup without a full database backup. Typically a full database backup is performed once a day.

<b> Differential Database Backup</b>

A differential database backup contains only those data pages that have been modified since the last full database backup. Apart from this, a differential database backup is identical to a full database backup.

The size of a differential backup is much smaller than the size of a full database backup. An example of integrating differential backups in a backup strategy is to perform a full database backup only once a week and to perform differential database backups daily.

Differential database backups are optional. The backup strategy will become more complicated if it includes differential database backups.

Advantage of Differential Backups

Performing differential backups after a full database backup has advantages.

It can reduce the number of full database backups that have to be performed. For example, a schedule requiring a daily database backup could be replaced by a schedule requiring 1 database backup at the beginning of the week followed by 6 differential backups on other days of the week.

Differential backups can also be used as a means of reducing the time necessary for a restore operation. By performing additional differential backups between full database backups, the number of transaction logs that have to be applied in the event of a restore operation is reduced. Restoring data with a database backup is considerably faster than restoring data by applying logs.

<b> Transaction Log Backup</b>

Transaction log backups save the log files.

They are mandatory when you use the Full or Bulk-Logged Recovery Model since they are needed to truncate the log. Two subsequent transaction log backups do not contain redundant information.

Transaction log backups have almost no impact on performance and can therefore be performed when the workload is high.

This info is from the link below.

http://help.sap.com/saphelp_nw04s/helpdata/en/f2/31ad41810c11d288ec0000e8200722/content.htm

Hope it helps to better ur understanding.

Br,

Sri

Award points for helpful answers