Restore Backup

Restore the backup.

What ist the password for the sa to restore?

/opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P ${SA_PASSWORD}

Hello @daschmidt94,
if you have standard bwdata, then check under …/bwdata/docker/mssql.override.env. Otherwise under …/bwdata/env/mssql.env.

is only the SA_Password to change or localhost also?

Exclusive access could not be obtained because the database is in use.

I’dont know the Database name

Check the variable globalSettings__sqlServer__connectionString under …/bwdata/env/global.override.env. That should give you the information to connect to database.

Maybe you need to specify port. Depending on how you are trying to access it localhost might be replaced with mssql as that is the domain that they use internaly.

Thanks, but there i can’t find the databasename.

Is it right, i must stop the database and then restore?

Database name seem to be vault.

Does this information help you?

I’ve not tried it myself.

Thanks now it works, the documentation is realy bad.

How you restore your data?

I backup the volumes themselves. I personally keep copies of my passwords also on KeePass.
The easier way would be to create backups of bwdata using rsync.

1 Like