VisualTime database restore utility

The VisualTime Database Restore Utility is useful in situations where the VisualTime database needs to be moved from a SQL Server to another or for disaster recovery purposes.

Requirements:
  • Microsoft .NET Framework 4.0
  • Existing VisualTime database created by the VisualTime server installation program on a SQL Server instance.
  • An existing VisualTime installation. It can be an existing production deployment or a newly created installation.
  • The version of the database in the backup file must match the version of the existing VisualTime installation.
  • VisualTime Database backup file. The utility requires a valid VisualTime database backup file. The backup file can be created from within the VisualTime Management Console (under Backup) or it can be created by SQL Server administrator using SQL Server administration tools.

How to use the utility:

The utility must be run on the server hosting the IIS instance where VisualTime is installed.

Once launched, the utility will attempt to detect an existing installation of VisualTime. If an existing installation is not detected, the utility will try to find the \VisualTime folder.

The following information must be provided:
  • SQL Server name and instance (if different than default)
  • SA account or equivalent 
  • SA password
  • The path where VisualTime is installed (by default C:\Program Files (x86)\VisualTime
  • The path where the VisualTime Database backup file is stored.
After all the required fields have been populated, press the "Restore database" button.
The operation can take a few seconds or minutes, depending on the size of the database to be restored.

Once complete, the existing VisualTime database will be overwritten with the one from the backup file, however, the VisualTime settings will be preserved from the existing installation.

You can download the VisualTime Database Restore Utility from here: http://www.visualtime.com/download/VisualTimeDatabaseRestoreUtility.zip

Article ID: 31, Created On: 7/4/2013, Modified: 7/4/2013