Create Sandbox Database

To access: VOTER FOCUS ADMIN > System Utilities > Database Utilities > Create Sandbox Database

This program creates a copy of your Voter Focus database that can be used for training or testing. The Sandbox database does not connect to FVRS, so it can be used regardless of whether FVRS is running and can be recreated whenever the county has the need. See Using Voter Focus without FVRS for a list of the functions you can perform on the Sandbox database.

The name of the Sandbox database is Vr6Sandbox. The program creates Vr6Sandbox by making a copy of a full backup of the production (Vr6) database.

If you have an existing version of the Sandbox database and you want to refresh it with the latest information, simply create the Sandbox database as you did the first time. The existing Sandbox database will be completely replaced.

You are not able to recreate the Sandbox database if there are users currently working in the database.

  1. On the server where the backup of the production database was made, ensure that you are using the production database. If not, in the top-right corner of the Console, click the Database drop-down list and select Normal Database.
  2. Go to VOTER FOCUS ADMIN > System Utilities > Database Utilities > Create Sandbox Database.

    3. This displays a list of recent backups of the production database with the most-recent one highlighted. You can change to an earlier backup, if there is some reason to not use the most-recent; typically, you will use the most-recent one. Below the backup list, is the default location where the two files making up the database will be stored when the Sandbox database is created/recreated. Under normal circumstances, you don't need to change this location.

  3. Click Create Database.

    4. If this button is disabled, it means one or more users are working in the Sandbox database. To find out who they are, click Cancel, and then click Show Current Usage on the VOTER FOCUS ADMIN tab. This lists the users who are running Voter Focus and the database they are working in. Once the Sandbox users have exited Voter Focus or switched to another database, you can repeat this procedure from step 1.

  4. If a Sandbox database already exists on your system, you are asked to confirm replacing it with a new one. Click Yes to start the creation process.
  5. When you see the message Success!, you'll know the Sandbox database is ready for use. Click Cancel to finish.
  6. To switch to the Sandbox database, in the top-right corner of the Console, click the Database drop-down list and select Sandbox Database.