Skip to Content
author's profile photo Former Member
Former Member

backup

hi,

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

Thanku

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Jan 09, 2007 at 01:43 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 09, 2007 at 01:35 PM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 09, 2007 at 01:59 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.