Backup Multiple But Not All?

[andrewteg]

We are using the SJA to backup all of our databases and it’s going great, but we have some large databases that we do not want as part of the backup. Is it possible to backup multiple databases but not all of them by either including (whitelist) or excluding (blacklist) certain databases? I do not see this option and am not sure if I missed it or if it just is not an option at this time.

 

Thanks,

Andrew

 

[sathish]

Hello,

 

You can do this by creating multiple jobs from Scheduled backup and automate using a singe batch file.

 

Please refer: http://faq.webyog.com/content/27/35/en/can-i-execute-more-sja-jobs-at-the-same-time.html

 

You can create the job file for one job in the wizard and simply edit it for use with other jobs, if you feel this is easier than using the wizard multiple times. Also please refer this FAQ which will be helpful for understanding SJA:  http://faq.webyog.com/content/27/114/en/introduction-to-the-_sqlyog-job-agent_-sja.html 

 

Regards,

Sathish

[Author]

Posts