This article describes how to restore the visitor id database manually using Microsoft SQL Server Management Studio. Use these instructions if you are:
Installing Microsoft SQL Server manually, OR
Restoring the visitor id database from a backup.
Open Microsoft SQL Server Management Studio:
via Start Menu:
Click ‘Start’ and type ‘SQL Server’.
The results should show ‘Microsoft SQL Server Management Studio xx’. Click this result item.
OR via File Explorer (for Microsoft SQL Server Management Studio 18):
Open Windows File Explorer.
Navigate to: C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE
Double click the ‘Ssms.exe’ file.
Connect to the visitor id instance:
Make sure the ‘Server Type’ is set to ‘Database Engine’
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.
Change ‘Authentication’ to ‘SQL Server Authentication’.
Type ‘visitorid’ without quotes into the ‘Login’ field.
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.
Press the ‘Connect’ button.
Expand the ‘Databases’ node by clicking the ‘+’ sign:
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:
Right click the ‘Databases’ node and click the ‘New Database…’ menu item:
In the ‘Database name’ field type in ‘visitorid’ without quotes, then click the ‘Ok’ button:
The visitor id database will now be created. Right click the visitor id database and click the ‘Tasks > Restore > Database…’ menu item:
In the ‘Restore Database’ window ‘General’ page:
In the ‘Source’ group choose the ‘Device’ option.
Press the ‘…’ elipses button to the right on the ‘Device’ option:
In the ‘Select backup devices’ window, make sure the ‘Backup media type’ is set to ‘File’, then click the ‘Add’ button:
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:
Press the ‘OK’ button again.
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:
In the ‘Options’ page ‘Restore options’ group, tick the ‘Overwrite the existing database (WITH REPLACE)’ checkbox, then click the ‘OK’ button:
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 firstname.lastname@example.org .
Congratulations. The visitor id database should now be restored successfully.
Was this post helpful?
Let us know if you liked the post. That’s the only way we can improve.
Click on the different category headings to find out more. You can also change some of your preferences. Note that blocking some types of cookies may impact your experience on our websites and the services we are able to offer.
Essential Website Cookies
These cookies are strictly necessary to provide you with services available through our website and to use some of its features.
We provide you with a list of stored cookies on your computer in our domain so you can check what we stored. Due to security reasons we are not able to show or modify cookies from other domains. You can check these in your browser security settings.
Other external services
We also use different external services like Google Webfonts, Google Maps, and external Video providers. Since these providers may collect personal data like your IP address we allow you to block them here. Please be aware that this might heavily reduce the functionality and appearance of our site. Changes will take effect once you reload the page.
Google Webfont Settings:
Google Map Settings:
Google reCaptcha Settings:
Vimeo and Youtube video embeds: