A product from

• Frequently asked questions
• News archive
• Help and tutorials
  • User Interface
  • Functions and tools
  • Configuration and customization
  • Detailed information
  • Tutorials, tips and tricks
    • Helium Web Service API
    • How to connect your iPod and iPhone device
    • Installing Microsoft SQL Server 2008 Express
    • Setting up a working MySQL connection
    • Translating into your language
    • Using Helium Music Manager in a multi-user environment
    • Video tutorials
    • Creating or restore a MS SQL database backup on a remote server
    • Creating or restore a MySQL Database backup on a remote server
• Forum
• Customer Center
• Contact us
• About us

Creating or restore a MS SQL database backup on a remote server

Creating or restore a MS SQL database backup on a remote server

When you use the Network version of Helium Music Manager, you can choose to have your database stored on a separate server to reduce the workload on your local machine.

Databases stored on external servers cannot be backed up with Helium Music Manager’s backup tool, mainly because of various permissions and related things.

To create a backup of your database stored on your server, you will need to use the functions in SQL Server Management Studio (available for free).

Follow these steps to create a backup using SQL Server Management Studio:

1. On your server machine, start SQL Server Management Studio
2. Check that the Server name is correctly set and that Windows Authentication is selected.
3. Click the Connect button to connect to SQL Server.
4. In the Object Explorer (left sidebar tree), expand the Databases node
5. Locate your database name and select it
6. Right-click and select Tasks > Back Up...
7. In the destination section (lower part of the dialogue), verify that the Disk radio button is selected and that an entry in the list below exists. If a valid entry exists in the list, skip to point #12
8. Click the Add... button
9. In the dialogue that opens, check that File name is selected and press the (…) button
10. Ensure that your MS SQL Server Backup folder is selected (this should be done by default) and enter a filename, for example <databasename>.bak and press OK.
11. Click the OK button to close the Select Backup Destination dialogue.
12. Click the OK button in the Back Up Database dialogue to start the backup.

Follow these steps to restore a database using SQL Server Management Studio

1. On your server machine, start SQL Server Management Studio
2. Check that the Server name is correctly set and that Windows Authentication is selected.
3. Click the Connect button to connect to SQL Server.
4. In the Object Explorer (left sidebar tree), select the Databases node.
5. Right-click the databases node and select Restore Database...
6. Select the database name you would like to restore in the To database edit box.
   Note: If the database does not exist, a new database will be created.
   If it exists, the existing database will be overwritten.
7. In the Source for restore group, select the From device radio button and click the (...) button to the right of the edit box.
8. In the Specify Backup dialogue that is opened, ensure that Backup media is set to File and click the Add button.
9. In the Locate Backup File dialog, browse through your backup folder and select the backup file, for example <databasename>.bak.
   Press OK to select this backup.
10. Click the OK button to close the Specify Backup dialogue.
11. In the Select the backup sets to restore list, ensure that the Restore checkbox for the entry added in steps 7-10 is checked.
12. In the Select a page left sidebar, select the Options entry.
13. In the Restore options group, ensure that Overwrite the existing database (WITH REPLACE) is checkmarked.
14. Click the OK button to perform the restore operation.