Forum Discussion

sraj_82's avatar
sraj_82
Level 2
11 years ago

Full and then Incremental backup

Hi

We need to implement this Feature in our Backup Environment.

Let us know whether there is any such option can be configured using  Backup  exec 2012.

　

Consider If we are taking a backup file of SQL database and retain locally in disk for 2 days using SQL backup plan.

Assume a Scenario:

Sql database backup file generated on Monday = testdbday1.bak

Sql database backup file generated on Tuesday = testdbday2.bak

By having an Job configured for the Full File System backup on above server the First day (Monday) file system backup will take the testdbday1.bak file to Tape.

On 2nd day the testdbday2.bak file will be generated, also the testdbday1.bak file will be already available in the same directory.

Now on 2nd day the backup exec has to to backup the Newly created/Modifed file alone to  into tape and not the previous day backedup file(testdbday1.bak)

This will avoid the testdbday1.bak file backup again to tape.

Let me know how such job can be created in backupexec 2012

 

Regards

Rajesh

2012
Backing Up
Backup and Recovery
Backup Exec
Windows Server (2003-2008)
  • pkh's avatar
    pkh
    11 years ago

    Suppose you can do what you want, then when you do a restore, you would need to restore the full backup plus ALL the incremental backup since that backup.  If you need to do a restore at the end of the year, just calculate how many incremental backups that would be.  It will be a nightmare and your restore time will take forever.  In your example, you would need to restore the full backup taken on 14th Feb plus ALL the incremental backups until 25th Aug.

    You should always do more frequent full backups to reduce your backup chain.  I cannot tell you how often because it would depend on your requirement.  A weekly full backup would be about the norm.

  • pkh's avatar
    pkh
    Moderator
    11 years ago

    When you create a scheduled backup job, it will automatically included a full backup job and an incremental backup job. This will meet your requirement. The incremental backup job will only backup new or modified files since the last full or incremental backup

  • sraj_82's avatar
    sraj_82
    Level 2
    11 years ago

    hi Thanks for your reply.

     

    My exact requirement is how to continue with one time full backup and then all daily schedule as Incremental job for next one year.. (From Current Feb-14- Next Feb-15)

    We are going to have all the tapes appendable after 4 weeks.

     

    for ex : By implementing above one,  If I want to restore an data of  25th Aug-14 on 1st Sep-14 , whether the full backup job reference which is taken in Feb-14 will be available in the server or in tape reference??

    If it is not going to available then what is the min cycle recomended to have full backup of the Particular file system location

    Pls clarify

     

    Regards

    Rajesh

     

  • pkh's avatar
    pkh
    Moderator
    11 years ago

    Suppose you can do what you want, then when you do a restore, you would need to restore the full backup plus ALL the incremental backup since that backup.  If you need to do a restore at the end of the year, just calculate how many incremental backups that would be.  It will be a nightmare and your restore time will take forever.  In your example, you would need to restore the full backup taken on 14th Feb plus ALL the incremental backups until 25th Aug.

    You should always do more frequent full backups to reduce your backup chain.  I cannot tell you how often because it would depend on your requirement.  A weekly full backup would be about the norm.