VSys One: Volunteer Management Software

Previous Topic

Next Topic

Book Contents

Book Index

Restore From a Backup

This tool lets you restore your VSys data from a previously backed-up version. It overwrites your existing data with the data from the backup. All existing data in your system will be overwritten.

You can only restore backup files made by VSys One, not backups made by GMS. Backups made by VSys, if they include all tables, will also include all GMS data, if present.

Steps in this task

  1. All other users must exit VSys One, VSys Live and GMS, the VSys Kiosk(s) must be closed, and if VSys Live or VSys Anywhere are in use, VOXI must be shut down.
  2. Open the Restore from a backup tool. Or, immediately after double clicking on the VSys One icon, press and hold the left Ctrl key on your keyboard until the VSys One Database selector window appears. Select the appropriate database, click on the Tools link, then select Restore from a backup to this database.
    Linked Graphic
  3. Browse to the backup file that you want to restore.
  4. Select the file and click the Open button. The Table restore screen opens.
    Linked Graphic

If any of the tables in the database are locked (or anyone at all is in GMS 5, GMS 6 or VSys One when using a NexusDB database), the restore process can fail for one or more tables. If this happens, it's important to get everyone out of the system and try again: mixing and matching some old tables with some new tables will leave your data in an inconsistent state.

VSys will complain very loudly if any key tables are missing from the backup. It does this to help ensure that you don't accidentally restore a partial backup into your database, leading to unintentionally inconsistent data.

  1. VSys shows the current database you are connected to and any notes about the backup on the right-hand side of the screen.
  2. All of the tables are checked when you access this screen. If there are any tables you do not want to restore, click on the checkbox to de-select them.
  3. Click on the Restore button to start the restore process.

If you started the restore process from the Administrator tools panel, VSys will need to restart after the restore process is complete. We also recommend running the Index update tool after restoring from a backup.

The backup file you selected shows in the Backup file to restore field. Check to be sure this is the correct file.

Throttling

To tell VSys to intentionally slow the restore process, VSys supports a "Throttle" option:
[Magic]
RestoreThrottle=z
where z is the % slowdown to use; a value greater than zero causes VSys to pause, after each posted transaction, for z% of the time that that last transaction took to run. This is intended to allow a restore to run without bogging down the underlying database server.

See Also

Tools

Apply Certification Automatic Creation Rules

Attachments Analyzer

Automatically Create Eligibility/Intake Checklists

Data Backup

Bulk Value Updater

Check for Duplicated IDs

Check for Zip/Postal Code Updates

Concurrent Users Monitor

Create and Manage Data Encryption Keys

Database Merge Tool

Enter VSys One Registration Codes

Find Duplicate Assignments

Find Duplicate E-mail Addresses

Find Overlapping Volunteer Hours

Fix Recurring Assignment Detail Gaps

Index Update Tool

Letters Purge Tool

License Information

Make a Local Backup of VSys One in Another Folder

Photo Resize Tool

Purge Old Trace Records

Recalculate the Bonus Hours for Volunteer Hours

Recalculate the Value of Volunteer Hours

Special Table Tools

SQL Commands to Database

Table Permissions Diagnostics

Trace Analyzer