Question
How to backup your SQL database?
Answer
In order to create a back-up please follow these steps:
Step 1
Open the SQL Server Management Studio and connect to the correct instance.
Step 2
Unfold the Databases folder.
Step 3
Right click on myQA-ArchiveDB - Task - Back Up. A pop up will open.
Step 4
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.
Step 5
By clicking OK the back up will be created. Depending on the size of the database this might take a few minutes.
Step 6
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.