Restoring the visitor id Database Manually

This article describes how to restore the visitor id database manually using Microsoft SQL Server Management Studio. Use these instructions if you are:

1. Installing Microsoft SQL Server manually, OR
2. Restoring the visitor id database from a backup.

Instructions:

1. Open Microsoft SQL Server Management Studio:
   1. via Start Menu:
      1. Click ‘Start’ and type ‘SQL Server’.
      2. The results should show ‘Microsoft SQL Server Management Studio xx’. Click this result item.
   2. OR via File Explorer (for Microsoft SQL Server Management Studio 18):
      1. Open Windows File Explorer.
      2. Navigate to: C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE
      3. Double click the ‘Ssms.exe’ file.
2. Connect to the visitor id instance:
   1. Make sure the ‘Server Type’ is set to ‘Database Engine’
   2. The default installed instance is named with the convention ‘PCNAME\VISITORID’. Replace PCNAME with the name of the SQL Server PC. Type this into the ‘Server Name’ field.
   3. Change ‘Authentication’ to ‘SQL Server Authentication’.
   4. Type ‘visitorid’ without quotes into the ‘Login’ field.
   5. Type ‘visitorid1$’ without quotes into the ‘Password’ field. This is the default password for the ‘visitorid’ user. If you have a custom SQL Server installation your login and password may differ. Contact the visitor id support team if you are unsure about the login and password for your SQL Server Instance.
   6. Press the ‘Connect’ button.
      
3. Expand the ‘Databases’ node by clicking the ‘+’ sign:
   
4. If the visitor id database doesn’t exist, you will first need to create one. Skip this step if the visitor id database already exists:
   1. Right click the ‘Databases’ node and click the ‘New Database…’ menu item:
      
   2. In the ‘Database name’ field type in ‘visitorid’ without quotes, then click the ‘Ok’ button:
      
   3. The visitor id database will now be created. Right click the visitor id database and click the ‘Tasks > Restore > Database…’ menu item:
      
   4. In the ‘Restore Database’ window ‘General’ page:
      1. In the ‘Source’ group choose the ‘Device’ option.
      2. Press the ‘…’ elipses button to the right on the ‘Device’ option:
         
      3. In the ‘Select backup devices’ window, make sure the ‘Backup media type’ is set to ‘File’, then click the ‘Add’ button:
         
      4. Navigate to the location of the visitor id backup file that you want to restore. The default location for the visitor id database backup file is: C:\ProgramData\visitorid\Setup\visitorid.bak . Once selected click the ‘OK’ button:
         
      5. Press the ‘OK’ button again.
      6. The ‘General’ page should now look like this image. Make sure the ‘Destination > Database’ is set to ‘visitorid’ and the ‘Restore plan > Backup sets to restore’ row has the ‘Restore’ checkbox ticked. Then press the ‘Options’ page:
         
      7. In the ‘Options’ page ‘Restore options’ group, tick the ‘Overwrite the existing database (WITH REPLACE)’ checkbox, then click the ‘OK’ button:
         
      8. The visitor id database will now be restored from the backup file. If you receive errors during this process at any time, please take screen shots of the errors and send an email to support@visitorid.com.au .

Congratulations. The visitor id database should now be restored successfully.