Backup & recovery of the VTS

VTS supports backing up and restoring the entire system. This can be done either

• on the same computer

• on a different computer

However, a few important considerations apply, and all relevant files must be backed up.

The VTS stores data in two locations, both of which must be included in the backup:

1. The wts database in the SQL server

2. The WordTemplate folder under %PROGRAMDATA%\schuhfried\media

Backing up files

1. We recommend setting up a folder backup (using Windows Backup or by manually copying the folder to a safe location) for the WordTemplate folder located at %PROGRAMDATA%\schuhfried\media.

2. VTS includes a built-in feature for automatically backing up the SQL Server database. You can define a backup schedule that automatically backs up the database on a weekly basis. We recommend using this feature to set up regular backups.

   1. Open the Advanced configuration, go to Settings → General Settings → Database and configure an automatic backup using the appropriate settings.

      1. Make sure that the backup is only performed when the VTS is not in use.

         

3. In addition, a manual backup of the SQL database can be performed:

   1. Stop the WTS Service.

   2. Open the Task Manager → Services → right-click on WTS Service → Stop.

   3. Copy the files in the folder: %PROGRAMDATA%\Schuhfried\SQLDatabase to another secure folder.

   4. Restart the WTS Service.

Restoring the VTS on the same computer

1. You can restore the VTS to a previous, functional state by importing the file created by the automatic backup using the Restart restoration function.

   1. It is not possible to import a backup file that was created with an older VTS version.

2. Restoring the WordTemplate folder is not usually necessary, as the folder is still available on the same computer.

Restoring the VTS on a different computer

This procedure can be useful if you need to use a new PC and want to transfer the data from the VTS that was installed on your old PC. To do this, proceed as follows:

1. Perform a backup on the old computer and save the SQL database wts as described above.

2. Perform a manual backup of the WordTemplate folder under %PROGRAMDATA%\schuhfried\media (copy it to a USB stick, for example).

3. Install the VTS on the new PC (see Installation and configuration).

4. Copy the files created with the backup from the old computer to the corresponding folder on the new computer.

   1. The path where the backup files of the SQL database are stored can be found in the Advanced configuration.

      

5. Start the recovery via Start Recovery.

6. Copy the backed-up WordTemplate folder to %PROGRAMDATA%\schuhfried\media on the new computer.

7. If you did not select ‘localhost’ as the server address in the server settings when installing VTS (i.e., you are hosting VTS at an address other than localhost), you must configure the SQL database using the update_identityserverconfiguration.sql script.

Notes

• The VTS version on the old and new PCs must be the same.

• The appropriate licenses must be available for installation on the new PC.