<< Click to Display Table of Contents >>
Navigation: Qalumma Installation >
Restore SQL Server database from back-up file
To restore a database back-up file of a Qalumma database the target SQL Server engine must be the same version or higher than the source SQL Server engine on which the back-up file was created.
Use the SQL Server Management Studio to restore the database.
Select Device and add a file via the ‘…’ button.
Add the correct database back-up file.
Make sure the files are restored in the correct location. By default the correct locations are selected.
If a database with the same name already exists select the Overwrite and the Close option.
Select the OK button to start the restore.
Remember the existing users! You need to add them later again.
Delete existing users (example 'efl' and 'mgr') and the '##QSS##' user.
These users will be recreated later.
Execute a query by selecting the ‘New Query’ button while the correct database is selected.
Enter the following commands in the query window and select the ‘Execute’ button.
update NB set SPV = '0.0.0.0'
exec sp_changedbowner 'bruce'
Update the Qalumma Neuralbase (see Neuralbase Update).
Check in the SQL Management Studio if the login ‘##QSS##’ is there. You may need to refresh the content of the Logins list.
Edit the ‘##QSS##’ login and change the User Mapping. Select the correct Neuralbase and add the roles ‘NeuralbaseAdmin’ and ‘NeuralbaseUser’.
If the user was as an administrator then also add the server role ‘securityadmin’.
Add the correct User Mapping.
The database (Neuralbase) is now restored and ready to use!
© Copyright, Qalumma Technologies BV