Skip to main content

Dear friends, your valuable help.🙏🏼
I have launched a SQL Server restore process but it has gone through only one stream, and I would like to know how I can make it go through more streams.

Thank you.

@FeRox How many streams are you using for backup the database(s)?

 


Hello @FeRox 

A SQL restore can only use the exact same number of streams that were used for the backup.

It will always and must use the same number of streams. Note in the GUI it might display just one stream however it is always using the same as the backup job you are restoring from and can not be changed. There was a GUI issue where it would always display one stream but that was resolved in latest FR and it is just a display restore is using the same as backup. To change the number of streams for backup you can edit the number on subclient properties. Default is 2.

https://documentation.commvault.com/2022e/expert/18168_configuring_data_streams_for_backups_using_sql_server_agent.html#procedure


Reply