09-26-2023 08:52 AM
Hello we have 500 SQL instances that we are running more than 20 hours.
We want to shorten the backup time for this SQL backup but not sure how we can improve it. I saw some technote that we will increase the BATCHSIZE however is there any bad effect on client server side if we increase it?
09-26-2023 10:20 PM
@justjuls I am sure all 500 do not take 20 hours.
you can start identifying and tuning only instances that really run longer. You may want to validate what network speed/CPU/memory/disk they are running with. Its also possible some of them route via a firewall. Try implementing Weekly Full / Daily Incr/Diff + log backups policy instead of Daily FULL + log backups.
There could be lot of other reason why they run longer.
I know its a time consuming process but worth doing it for the sake of reducing backup time.
Hope this helps.
09-26-2023 10:50 PM
500 SQL instances in one system or 500 SQL databases in one instance?
09-27-2023 08:35 AM
500 SQL DB instances in one server
09-30-2023 07:31 PM
09-30-2023 11:21 PM - edited 09-30-2023 11:30 PM
I do not know how your backup is configured, but I think that there are two solutions to your problem.
And of course, you can combine the two solutions in one. Configure seven policies with full and incremental backups. For the full backup, choose a different day of the week for every policy and run the incremental on every other day.