Who is this article for?

IT personnel responsible for managing Ideagen Quality Management.

IT access will be required.

It is good practice to backup your Ideagen Quality Management database regularly to ensure that in the unlikely event that you face a disaster recovery scenario you have a valid copy of the database to access.

This article outlines how to restore a database from a backup and is split into the following sections:

1. How to Restore a Backup
2. Further Reading

Need to create a backup? Visit How to Backup the Ideagen Quality Management Database.

1. How to Restore a Backup

Tip! You can browse to C:\Program Files\Gael Ltd\Q-Pulse Server\DBConnections.xml to review what databases are being used by your Ideagen Quality Management system. The catalog will include the database name.

To restore a backup of your database:

1. Open Microsoft SQL Management Studio.
2. Go to Object Explorer and expand the navigation tree until you can see the Ideagen Quality Management database.
3. Right click on the database name and select Tasks, then Restore and finally Database.

4. Select the From Device option, then in the next window, click the Add button.
5. The Windows Explorer window will appear - locate and highlight the database you have backed up and then click the OK button.

6. The database you selected will then appear below the "Select the backup sets to restore" section.
7. Tick the Restore box, then click Options at the top left of this screen.

8. Make sure the Restore As path matches the path where the database files are held. The SQL Express default path is C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data
9. Tick the Overwrite the existing database box, then click OK.

10. Once the restore has been completed, highlight the database in the Object explorer and then click on the New Query window on the toolbar.
11. Copy and paste the following script into the query window:
    
    exec sp_change_users_login 'Auto_Fix', 'QPulseAppUser'
    
    
12. Right click on the query and select Execute.

2. Further Reading

• How to Backup the Ideagen Quality Management Database
• Ideagen Quality Management IT Toolkit