Forum Discussion

Cr13's avatar
Cr13
Level 3
3 years ago

Restore multiple MSSQL database

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.

  • 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

  • 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

  • Thank you for your answers :) :) :)

    Stéphane.