I have a SQL Instance with 5000+ small DB (each DB size less than a GB), i have configured 4 streams, however i see all streams are used for single DB, is there any settings to configure backup that can run 4 DB (one DB each stream) parrallely ?
Do let me know
So you mean you have one subclient with multiple dbs? and where did you change the stream count?
At this point, all the streams will be used for one DB. Is there a reason why you are looking to have multiple DBs in parallel?
Since the size of each DB are small, running each DB in seprate channel may decrease the time window. I was thinking to explore the option, We have similar situation for one more SQL DB where single instance has more than 10000 DB and backup runs really slow
you can increase the channel in subclient properties
Data Storage Policy , number of streams for data backup
Log Storage Policy , Number of streams for T Log