SQL backup with 5000+ DB in single instances

Last post 02-18-2020, 11:12 AM by Sunny48. 4 replies.
Sort Posts: Previous Next
  • SQL backup with 5000+ DB in single instances
    Posted: 02-16-2020, 9:31 AM

    Hi 

    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 

  • Re: SQL backup with 5000+ DB in single instances
    Posted: 02-17-2020, 8:12 AM

    So you mean you have one subclient with multiple dbs? and where did you change the stream count?

  • Re: SQL backup with 5000+ DB in single instances
    Posted: 02-18-2020, 9:58 AM

    Hi,

    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?

     

    Thanks,

    Karthik

  • Re: SQL backup with 5000+ DB in single instances
    Posted: 02-18-2020, 11:05 AM

    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

  • Re: SQL backup with 5000+ DB in single instances
    Posted: 02-18-2020, 11:12 AM

    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 

The content of the forums, threads and posts reflects the thoughts and opinions of each author, and does not represent the thoughts, opinions, plans or strategies of Commvault Systems, Inc. ("Commvault") and Commvault undertakes no obligation to update, correct or modify any statements made in this forum. Any and all third party links, statements, comments, or feedback posted to, or otherwise provided by this forum, thread or post are not affiliated with, nor endorsed by, Commvault.
Commvault, Commvault and logo, the “CV” logo, Commvault Systems, Solving Forward, SIM, Singular Information Management, Simpana, Commvault Galaxy, Unified Data Management, QiNetix, Quick Recovery, QR, CommNet, GridStor, Vault Tracker, InnerVault, QuickSnap, QSnap, Recovery Director, CommServe, CommCell, SnapProtect, ROMS, and CommValue, are trademarks or registered trademarks of Commvault Systems, Inc. All other third party brands, products, service names, trademarks, or registered service marks are the property of and used to identify the products or services of their respective owners. All specifications are subject to change without notice.
Close
Copyright © 2020 Commvault | All Rights Reserved. | Legal | Privacy Policy