Question
By default the databases are saved on C which hence is packed quickly. How can I move the myQA/ Compass DB on anther drive?
Answer
Step 1
Create a valid back-up of your database.
Step 2
Open the SQL Server Management Studio and unfold the database tree.
Step 3
Right click on the database - Task - Restore - Database
Step 4
Under General choose the back-up you have created in Step 1.
Step 5
Under Files tick the Relocate all files to folder option. Type in the blank space the new path (location where the DB should be saved).
Step 6
Under Option choose Overwrite the existing database (Attention: It is highly important that you have a valid back-up of the database, as corrupted data might lead to a crash).
Step 7
Press OK to execute the restore task.
In order to learn how to check if moving the database was successful click here.