backup in 6.5

  • I'm looking at the vendor backup. Then, I saw this

    DUMP DATABASE ABC TO ABC_Data_Dump WITH NOUNLOAD, STATS = 10, INIT , NOSKIP

    every 3 days at 3:00 AM

    DUMP DATABASE ABC TO ABC_Data_Dump WITH NOUNLOAD, STATS = 10, NOINIT, NOSKIP

    every 3 days at 3:00 AM

    The difference is INIT & NOINIT and doing in the same time.

    INIT - overwrite a previous dump file.

    NOINIT - add to existing dump file.

    Is there a purpose doing this? or reason behind this? any advantages or it is advisable?

     

  • It means only 3 days backups are kept in the backup device and will be recycled after that to keep the backup device in reasonable size.

  • why there is separate job for each INIT & NOINIT? why not just one INIT or NOINIT, know what I mean?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply