Who is this article for?
IT personnel responsible for managing Q-Pulse.
IT access will be required.
It is good practice to backup your Q-Pulse 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:
Need to create a backup? Visit How to Backup the Q-Pulse 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 Q-Pulse system. The catalog will include the database name.
To restore a backup of your database:
- Open Microsoft SQL Management Studio.
- Go to Object Explorer and expand the navigation tree until you can see the Q-Pulse database.
- Right click on the database name and select Tasks, then Restore and finally Database.
- Select the From Device option, then in the next window, click the Add button.
- The Windows Explorer window will appear - locate and highlight the database you have backed up and then click the OK button.
- The database you selected will then appear below the "Select the backup sets to restore" section.
- Tick the Restore box, then click Options at the top left of this screen.
- 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
- Tick the Overwrite the existing database box, then click OK.
- Once the restore has been completed, highlight the database in the Object explorer and then click on the New Query window on the toolbar.
- Copy and paste the following script into the query window:
exec sp_change_users_login 'Auto_Fix', 'QPulseAppUser'
- Right click on the query and select Execute.