What is 2x4 Backup and Replication?
Installation & Setup
Unzip the files
Installing the License file
Defining a Intelligence/Data collection
Manually creating Backups
Creating backups with the command line & task automation
Comments and Limitations
UNICOM INTELLIGENCE (formerly IBM SPSS Data Collection / SPSS Dimensions) does not offer exports or backups of individual projects. While a full system backup and restore can be created with generic backup software, the export of individual survey projects is not an easy task. There are multiple folders, files, databases, tables and hundreds of central stored properties which need to be individually considered for a backup and restore operation. Also different servers and database need to be referenced with their own names inside the complex database structure and content.
Backing up individual projects is HIGLY recommended, because a simple user error (like deleting a project) cannot be recovered with a full restore, as other user modifications or respondent data might be lost if they were stored after the relevant problem. When survey projects are finished, they still consume space and memory on the servers. Many administrators avoid deleting projects because of the lack of archiving and restoring utilities within INTELLIGENCE/DATA COLLECTION.
Another frequent task for system managers is moving running projects from one server to another server, e.g. a server with more RAM, disk space, a newer version of the software or just in a different network segment.
2×4 Backup & Replication helps in all these situations. It allows the export of individual projects with all associated folders, files, databases, tables, security information and DPM properties. Each project is stored in a secured file and can be restored on the same server or on a different environment with different storage settings. 2×4 Backup & Replication registers all system properties in the new environment, so that a seamless continuation of work is possible.
With 2x4 Backup & Replication you can
To use 2x4 Backup & Replication, we recommend it be installed directly on one of the DC interview servers. This ensures that all Intelligence/ Data Collection components are already installed and that security settings are in place. However you can run 2x4 Backup & Replication from another (desktop or server) machine within your network if all components are installed on that machine as well as the server. You must confirm that you can access the server DPM and the database from such a machine. Many users do not have proper permissions to access the server database, so please confirm before attempting to run backups off the server itself.
Several different INTELLIGENCE/DATA COLLECTION server versions (32bit or 64bit, DC 4.5 to DC 7.0.1) are supported.
Setting up the program is done by unzipping the program package into a fresh directory. Please make sure that you received or downloaded the correct version of the zip file. The name of the zip file contains the supported version of IBM SPSS Data Collection and the Architecture (32/64). The architecture depends on the server installation of the Intelligence/Data Collection software.
The version (32bit or 64bit) of 2x4 Backup must match the installed version of the INTELLIGENCE/DATA COLLECTION Server, which might not exactly match the OS.
For example: If you are running a Windows Server 2012 R2 / 64 Bit Server BUT you have installed IBM SPSS Data Collection Server 7.0.1 / 32Bit, you will need to use the 32 Bit version of 2x4 Backup and Replication. The 64 Bit version, would not able to connect to the DC server components.
After installation, the program is running in demo mode. This allows the first 5 projects that were created on that DC server to be used for creating test backups. The projects might be in different folders or company accounts with INTELLIGENCE/DATA COLLECTION and possibly you will need to search for those specific projects in different sub-folders. All other INTELLIGENCE/DATA COLLECTION projects will be visible within the Back Up tool, but they cannot be selected until the Backup tool license is activated.
The license status is shown in the splash screen after you start the program or available from the Info Link in the main screen.
To activate the complete version you need to copy your license file ‘license.dat’ into the same directory
that contains the backup program. Restart the program and the project list will then show the full list of projects on the INTELLIGENCE/DATA COLLECTION server, all of which can now be backedup.
When you first start 2x4 Backup & Replication, it shows an empty server list. The first task for setting up a new server is to click on the Add button above the server list. This opens a new window.
The following list shows the needed values to enter:
Click on the Add Server Button to add that server to the configuration. If the server cannot be accessed, there will be an error message. In that case please check the details again. If you have any doubts about the connectivity, please try to use DPMExplorer (part of the DDL) to connect to that particular server.
If the server can be accessed, the settings are stored in a configuration file located in the user’s AppData directory (Example: C:\Users\USERNAME\AppData\2x4BackupAndReplication).
After a backup file is sucessfully created, it is possible to store a copy of the file on a remote data location via SFTP. Click on the Remote Location Tab to set up the access details. After selecting SFTP from the Drop List, you can enter your details for the SFTP Server, User/Password and the root directory for the backups.
This area shows some option for optimizing the backup process. If the program shows long waiting times during startup or also when doing backups of projects with quota definitions, it might be worth to try these options. 2x4 Backup & Replicate will use direct database access (and not the official DPM) for some delaying tasks like getting the project lists, etc.
After sucessfully adding a server it will appear inside the server/project list. The server name will be replaced with the name found inside DPM – even if you entered an IP address when defining the server in 2x4 Backup. Underneath the server you will see all available projects.
It is possible to edit the server details or to Add / Remove additional servers.
After starting 2x4 Backup & Replication, you will see the registered server(s) and the projects for the server. The projects show their label followed by the ID in parantheses. If the projects are within sub-folders, you will see that structure as well.
Select the projects you want to backup by clicking on checkbox to its left. If you check a folder, then all the projects inside the folder will be processed (independent of their checkbox status). If you check a server then all projects on that server will be processed.
The QS (Quick Select) Button is useful if you have a list of project names that you would like to process. Copy the names (one in each line) from Excel or Notepad into the clicpboard and then press this button. After that all of those projects will be selected.
The standard backup usually includes all the different parts of an INTELLIGENCE/DATA COLLECTION project, but sometimes you may want only to backup specific aspects. For that reason you can check, or uncheck, the individual parts in the Backup Details pane.
When you are happy with the settings, click on the Backup Button at the bottom of the window. If you have not yet selected a backup folder, you will be prompted to specify one right now, then click the OK button.
The Backup process will now start for each individual project. You can see at the bottom of the window the different phases for the backup and for large projects (e.g. many respondents, large Participants table) a running number count also shows you the progress of the record processing.
After the backup is finished, you will see a message box informing you how many backups were sucessfully created. If for some reason a backup could not be created, you will see this information in the backup log.
If you want to create additional backups you can do so right now. The program will re-use the same directory for any following backup.
You can now go to that folder to drill down and see the various subfolders, which mimic the FMRoot folder of the INTELLIGENCE/DATA COLLECTION product. Notice the date and time of the backup have been appended to the folder name.
2x4 Backup & Replication can be used in an automated way without invoking the user interface. The following parameters can be used with the commandline:
If you start the program this way, all (selected) projects from all registered servers will be processed. The registration of the servers is still done inside the GUI and it is re-used in the command line mode as well. The parameters (e.g. BackupDir, BackupProjects) can be used in any order. Do not use any spaces around the = sign, as spaces are separators for the commands. If the value for directory contains any spaces, please use parantheses like shown below.
We highly recommend using 2x4 Backup & Replication in a task scheduler to create regular backups. This can be done in the background using the command line option of the backup program.
We recommend creating a batch/command file which contains a similar content:
Whenever you start the batch file, all projects will be processed and it is also possible to add a system Task Scheduler with this file. Please make sure to start the scheduler with a user that has all sufficient rights to DPM, the database and also the backup target.
The commandline backup always uses the name creation Date/Time as Directory. This will make sure that you do not lose any backup files. Depending on your backup schedule, please make sure to delete old backup files from time to time. Also to mention is that the command line option does not allow any passwords for the backup (the GUI version does allow passwords to be specified) as you would need to store the password inside the batch file in clear text and this would make no sense from a protection point of view.
To restore individual or multiple projects, you need to select the second tab of 2x4 Backup & Replication. The first example shows the selection of only one project. With a click on the … button at the left, you will be able to select the backup file you want to restore.
Once you selected the file click on Open more information will be populated within the form.
The left box shows you any comments which have been used during the backup of the project. In our example this box is empty. The Restore Details on the right show all available options for the restore. All options which are not supported by the backup file are grayed out. As an example, if the backup file does not contain Sample Management information, then you cannot select the Sample / Participants Table(s) checkbox.
For some fields like Project Name or Database Server, you can see the original values from the backup file in gray italics to the right of the fields. The individual fields are:
In this example I will create a new project named CGI_HOTELSURVEY2.
After you click Restore it will take a few minutes to complete the process. A status bar at the lower left of the Backup Form will be updated as the process continues.
My project has now been restored and launched, and I can now test it.
The Logs tab shows you various information about the license file and the status of your license. It also shows a list of all steps of the backup process. You can see in the logs if any errors occurred during the backup. If you create a backup of only one project and there is an error occurring, usually a message box appears and you need to click on ok. However if multiple projects are processed in the backup, there are be no message boxes and all problems are added to the log files.
In addition to the log tab, a more detailed log file is generated inside the program directory (where the exe file is located). There is one log file for every day you are using 2x4 Backup and Replication. If there are any problems with the software, Tech Support might ask you to send these log files.
Use the following links for downloading 2x4 Backup & Replication. You need to use the correct version, depending on the Unicom Data Collection version installed. If you require another version (e.g. 32 Bit or older versions) please contact us.
After downloading the zip file, please expand everything to a directory and copy your license file to that folder.
|Unicom Intelligence 7.x 64 Bit||https://download.2x4.de/2x4/2x4BackupAndReplication/22.214.171.124/2x4BackupAndReplication126.96.36.199_701_64Bit.zip|
|Unicom Intelligence 6.x 64 Bit||https://download.2x4.de/2x4/2x4BackupAndReplication/188.8.131.52/2x4BackupAndReplication184.108.40.206_601_64Bit.zip|
|Unicom Intelligence 5.6 64 Bit||On Request|
|Unicom Intelligence 4.5 64 Bit||On Request|
For more information about 2x4 Backup & Replication or other products please contact 2x4 or our authorized partners.
2x4 Solutions GmbH
Eichenring 23a 84562 Mettenheim Deutschland
Telefon: +49 8631 3516525 Email: firstname.lastname@example.org
2x4 Solutions GmbH Eichenring 23a 84562 Mettenheim Germany
Phone: +49 8631 3516525 Email: email@example.com