cancel
Showing results for 
Search instead for 
Did you mean: 

Restore multiple MSSQL database

Cr13
Level 3

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.

3 REPLIES 3

StefanosM
Level 6
Partner    VIP    Accredited Certified

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

Michal_Mikulik1
Moderator
Moderator
Partner    VIP    Accredited Certified

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

Cr13
Level 3

Thank you for your answers :) :) :)

Stéphane.