Question
I have lost my Compass installation completely. I did not have back ups but could save the Microsoft SQL Server folder. I have now installed Compass and the Database on another computer.
How to restore the Compass Database without having back up files (just with the database files)?
Answer
Step 1
Open the SQL Server Configuration Manager.
Step 2
Stop the Service of the Database that you want to restore.
Step 3
Go to the Database Folder on the new computer (something like: C:\Program Files\Microsoft SQL Server\XXX\MSSQL\DATA, whereas XXX stands for the version and name of your SQL Server instance)
Step 4
Replace all .ldf and .mdf files in this folder by the data you have saved from your old installation. Please make sure that the number and names of the old data files matches the new files.
Step 5
Go back to the SQL Server Configuration Manager and start again the service of the database.
Step 6
Open Compass and check whether the recuperation of the DB using the files worked. First time opening the application can take a bit because the DB files are read for the first time.