I have a SQL Server 2008 with more than 200 User databases. Some are larger than others and every two weeks or so a new db gets created.
Should I create only 1 maintenance plan backing up all 200+ databases or should I break them into 3 separate maintenance plans.
How much load does a backup plan generate on the server. Will it affect performance if I have them in the same Plan.
Some more details regarding the infrastructure.
I am using SSD's. The storage is all SATA, It's not a SAN but I have a network drive where I store the backups. I cannot backup to a tape. My backup strategy is Full once a week Differential every day. I am using SImple backup (Due to storage restrictions, cannot let logs grow and cannot have logs backup). The databases as I mentioned are roughly 10 GB around 10 or 12 DBs are 100 GB+ and I cannot use third party tools. I can create Maintenance plans