Forum Discussion

Claudio_Veronez's avatar
Claudio_Veronez
Level 6
14 years ago

easy one, mssql retention schedule

hello,

that maight be quiet simple.

I have a mssql online policy 
and  some schedules

anual       - retention 5 years
mensal   - retentinon 1 year
semana  - retencion 3 months
diario      - retention 2 weeks


so.. all of them R Automatic backups

there is one application schedulle for all of them, is that right?

and about the retention period should I put  5 years ??


Thanks
 

7.1.x and Earlier
Backing Up
Backup and Recovery
Best Practice
NetBackup
  • Marianne's avatar
    Marianne
    14 years ago
    We treat database policies different to normal policies:
    We create different policies for the different requirements - one for daily, one for weekly, etc so that the application schedule can be assigned the correct retention.

14 Replies

Sort By
  • Claudio_Veronez's avatar
    Claudio_Veronez
    Level 6
    14 years ago
    I´ll try some tests...

    Im not sure about it...

    Must the application schedule get the higher retention?

    Should I use one application schedule for each auto schedule ?



  • Marianne's avatar
    Marianne
    Level 6
    14 years ago
    We treat database policies different to normal policies:
    We create different policies for the different requirements - one for daily, one for weekly, etc so that the application schedule can be assigned the correct retention.
  • Claudio_Veronez's avatar
    Claudio_Veronez
    Level 6
    14 years ago

    we create one police per server/kind of data

    ex:

    svjava-oracle-online
    svjava-files


    we create a schedule for each retention/time to run.

    hourly/ weekly each one w/ a different retention.

    is that ok??

     

  • Claudio_Veronez's avatar
    Claudio_Veronez
    Level 6
    14 years ago
    The same policy,

    EX: mssql on line same template

    there is 4 schedules

    1 every day = retention 3 days
    1 every week = retention 1 month
    the application schedule is set for the higher retention -

    is that wrong??
  • Marianne's avatar
    Marianne
    Level 6
    14 years ago

    All of them will run against the same application schedule with that retention period - so you might as well have only one automatic schedule.

    I have always wondered why Symantec has actually added a retention period for automatic schedules - it means nothing as far as image retention is concerned.

    The manual says the following:

    The retention period for an Application Backup Policy schedule refers to the length of time that NetBackup keeps backup images.

    The retention period for an Automatic Backup schedule controls how long NetBackup keeps records of when scheduled backups have occurred.
  • Claudio_Veronez's avatar
    Claudio_Veronez
    Level 6
    14 years ago

    1) a backup w/ application retentions 3 days and automatic retention 1 week... and see what really gona heppen w/ my data.

     

  • Marianne's avatar
    Marianne
    Level 6
    14 years ago

    This TechNote says it can be done in one policy:
    http://seer.entsupport.symantec.com/docs/258640.htm

    Create different Application Backup schedules with different backup windows.
    Please note that it is very important the two "Backup Policy" schedules do not overlap. If they do overlap, unpredictable results can occur, and backups could fail to take place or could expire prematurely.


    I think this is why we have gone for the different policy per retention period.
  • Claudio_Veronez's avatar
    Claudio_Veronez
    Level 6
    14 years ago
    Thanks again Marine.

    I´ll read that tech note.

    I was thinking.

    if each automatic schedule can have "his own" retention and every auto schedule "calls" the application, why can I change the retention?

    I´ll do some tests.. and post the results here.


  • Will_Restore's avatar
    Will_Restore
    Level 6
    14 years ago
    This old document states:

    "Note: While there are Retention options for both the Application Backup schedule and the Automatic Backup schedule, it is the one on the Application Backup schedule which determines how long the images are maintained in the NetBackup images database and on tape."

    http://seer.entsupport.symantec.com/docs/277559.htm
  • Dion's avatar
    Dion
    Level 6
    14 years ago

    The implementation of SQL backup in NetBackup is a bit strange and sometimes a pain to work with but simply, the retention for the Application Backup schedule is used to determine how long the backup images will be kept (the schedule is not used by the server).  The schedule for the Automatic Backup is used to determine when a backup runs, the frequency and the window (the retention does not get used).

    As far as I can remember (it was quite a long time ago that I did the tests), the windows for both schedules are used.  The windows for the Application Backup schedule determines when backups initiated from client machines can be run and the windows for the Automatic Backups determines when the policy can run.

    Hope this helps