PDA

View Full Version : Backup Set config question



sprbck
April 4th, 2007, 09:28 AM
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

kkg
April 4th, 2007, 09:09 PM
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

sprbck
April 5th, 2007, 09:51 AM
Got it, thank you very much!

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

best regards,
rodrigo