Results 1 to 3 of 3

Thread: Backup Set config question

  1. #1

    Default Backup Set config question

    Hi!

    I have this server with several databases that i want backed up.
    However, for one specific table of one of the databases i want a different schedule and retention. So i configured two sets for this:

    SET 1 # ALL EXCEPT db_1.tb_1
    ------
    all-databases=0
    databases="db_2 ... dn_n"
    tables="tb_2 ... tb_n"
    database="db_1"

    SET 2 # JUST db_1.tb_1
    ------
    all-databases=0
    tables="tb1"
    database="db_1"

    Please advise on the correctness of this approach.

    I believe this could be easily solved with support for exceptions, but i couldn't find anything about that. Should we expect that for next release?

    Thank you,
    rodrigo
    Last edited by sprbck; April 4th, 2007 at 09:30 AM. Reason: Just remembered..

  2. #2
    Join Date
    Oct 2006
    Posts
    199

    Default

    Quote Originally Posted by sprbck View Post
    Hi!

    I have this server with several databases that i want backed up.
    However, for one specific table of one of the databases i want a different schedule and retention. So i configured two sets for this:

    SET 1 # ALL EXCEPT db_1.tb_1
    ------
    all-databases=0
    databases="db_2 ... dn_n"
    tables="tb_2 ... tb_n"
    database="db_1"

    SET 2 # JUST db_1.tb_1
    ------
    all-databases=0
    tables="tb1"
    database="db_1"

    Please advise on the correctness of this approach.

    I believe this could be easily solved with support for exceptions, but i couldn't find anything about that. Should we expect that for next release?

    Thank you,
    rodrigo
    The above will not work.

    The correct way to do this is to have 3 sets. One for all databases excpet db_1, second for all tables of db_1 except tb1 and third for just the tb1 table of db_1.

    Following will be the backup set configuration

    SET 1 # ALL EXCEPT db_1
    ------
    all-databases=0
    databases="db_2 ... dn_n"

    SET 2 # All tables of DB_1 except tb1
    ---------
    tables="tb_2 ... tb_n"
    database="db_1"

    SET 3 # JUST db_1.tb_1
    ------
    all-databases=0
    tables="tb1"
    database="db_1"

    Let me know if you have any more questions.
    --kkg

  3. #3

    Default

    Got it, thank you very much!

    I reiterate the suggestion of excludes configuration, would be cleaner.

    best regards,
    rodrigo

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •