How to restore a SQL database?
In order to create a back-up please follow these steps:
Open the SQL Server Management Studio and connect to the correct instance.
Unfold the Databases folder.
Right click on myQA-ArchiveDB - Task - Back Up. A pop up will open.
Under Destination choose a location for the back up. It is important that only one location is set under destinations. Delete all the locations/ paths that are not in use.
By clicking OK the back up will be created. Depending on the size of the database this might take a few minutes.
Repeat this process for the myQA-Main DB. In case you want to back up the Compass DBs you have to back up all 4 databases.