Skip to main content
Solved

SQL SERVER DATABASE RESTORATION STREAMS


FeRox
Byte
Forum|alt.badge.img+8

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.

Best answer by Scott Reynolds

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

View original
Did this answer your question?

2 replies

Ralph
Vaulter
Forum|alt.badge.img+7
  • Vaulter
  • 44 replies
  • February 21, 2023

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

 


Forum|alt.badge.img+14

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings