Query to set in email backups (number)

Hi all,

Is it possible to run a query to the master DB (on a multi server setup) to update all email accounts to receive 7 days of backup?
Some are 3, some 5 etc at the moment but due to been hundreds I was wondering if it is possible with a sql?
If it is, do I need to run the re-sync or anything else afterwards?

Thanks in advance

 

@Th0m do you know which query I have to run?

 

Thanks @Th0m. I assume I need to alter those tables only on the server that holds the control panel as it is a standalone on a multi server setup?

 

Thanks a lot, it worked fine.

Code:

UPDATE mail_user SET backup_interval = 'daily';
UPDATE mail_user SET backup_copies = '7';

 

@Th0m what about the web and database backup? Which are the tables/fields that need to be updated?