Solved

SQL SERVER DATABASE RESTORATION STREAMS

  • 20 February 2023
  • 2 replies
  • 121 views

Userlevel 1
Badge +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.

icon

Best answer by Scott Reynolds 21 February 2023, 16:25

View original

2 replies

Userlevel 1
Badge +5

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

 

Userlevel 6
Badge +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

Reply