06-07-2022 01:21 AM
Hi community,
In order to restore several DB , i can't select multiple database with API "Restore Microsoft SQL Server Objects".
I try also to restore by concatenating BCH files, and start with "Manage script files" but only the first DB is restored :(
Thank you for your help,
NB Master + Client : 9.1.0.1 / SQL server 2019
Stephane.
06-07-2022 01:59 AM
one possible solution is to create multiple BCH scripts, one for each database and a script that run the dbbackex command for every BCH script.
The command to start the restore from CLI is
dbbackex -f <BCH script name> -np
06-07-2022 03:08 AM
And in the GUI, you can click and initiate the restores DB by DB sequentially.
If you have backups on a disk, restores will really run in parallel then. If they are on tapes, the jobs will likely wait one for another, unless the backups are multiplexed.
regards
Michal
06-08-2022 01:58 AM
Thank you for your answers :) :) :)
Stéphane.