Restore
The Restore function takes a backup file that the Backup function has created, and restores it.
How to Restore your databases, options and templates
- Click on File > Restore... from the main menu.
- Click the Browse button to select the backup file (compressed zip file) in the folder where you previously saved your backup.
- Optionally select the contents you want to restore by clicking the Options tab and selecting the required items.
- Click OK to restore your previously backed up files.
- After the restore is finished Helium Music Manager informs you that "Helium Music Manager must now be closed to make the new settings active". It also confirms that the restore log file (helium-restore.txt) has been saved in your user data folder.
- Click OK to close Helium Music Manager. When Helium Music Manager is next restarted, the program will start; using the restored data.
Note:
- If your backup archive contains a Microsoft SQL Server database, you may need to select a "Native Microsoft SQL Backup Folder".
- A backed up Microsoft SQL Server database will be restored, but not automatically activated. You will need to activate this database by yourself from the Database Management dialog (CTRL-D).
- If you are using Windows Vista and Microsoft SQL Server, please make sure that you have proper access rights to the Native Microsoft SQL Backup folder.
- If your backup contains a MySQL database you will need to configure your MySQL server options from the MySQL Server Settings tab.
- A backed up MySQL database will be restored, but not automatically activated. You will need to activate this database by yourself from the Database Management dialog (CTRL-D).
Restoring a Microsoft SQL database
When you are restoring a Helium Music Manager backup containing a Microsoft SQL database using the Restore tool, this database will be restored automatically.
Restoring a Microsoft SQL database requires the following:
-
The Microsoft SQL server must have the same name as the server with which the backup was created.
-
The Microsoft SQL server must be running.
-
The "native" backup/restore folder (see above) must be set
Please note that when you restore a Microsoft SQL database from a Helium Music Manager backup, the current database will be overwritten.
To backup/restore "snapshots" of your Microsoft SQL database, please refer to your Microsoft SQL documentation.
If your server has been renamed, the restore operation will fail and you will need to manually restore the database backup.
To restore a Microsoft SQL database manually follow these steps:
-
Extract the Microsoft SQL database from the backup (the .zip file). The file is named mssqlbackup.bak and is located under the MSSQL folder.
-
Restore the mssqlbackup.bak file using your Microsoft SQL Management tool (e.g. Microsoft SQL Server Management Studio) using the restore command. For more details, please see your Microsoft SQL documentation/SQL Management tool documentation.