Question
I have lost my entire myQA installation. I do not have back ups but could save the Microsoft SQL Server folder. I have now installed myQA and the Database on another computer.
How to restore the myQA 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 myQA 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.