XperiDo Server Backup Procedure
XperiDo Server Backup Procedure
XperiDo Server Backup Procedure
XperiDo server
Table of contents
Table of contents.............................................................................................................................................................................................. 2
1.1 Installers........................................................................................................................................................................................... 4
2 Databases .................................................................................................................................................................................................. 5
This article explains the steps to take when you want to back up the XperiDo installation, configuration and
database on the XperiDo server.
XBintegrator = an enterprise service bus on which XperiDo is built. The XperiDo server is commonly
referred to as XBintegrator.
XperiDo website = the XperiDo website in IIS, which is loaded into CRM as an iframe. (applies only to
XperiDo for Microsoft Dynamics CRM)
1.3 Website
If you have XperiDo for Microsoft Dynamics CRM, you'll have an XperiDo website in IIS. It's a good idea to back
up its configuration as well.
You can find this file (web.config) in the website directory. You can find this directory by opening the website in
IIS and clicking Explore.
2 Databases
The most important part of the procedure is backing up the databases. There are multiple databases (depends
on which products you have):
XBintegrator database
You can find out which type of XBintegrator database you're dealing with, by checking the Custom driver tag in
the Database tag of the <installdir>/conf/xbconfig.xml file.
XperiDo for Microsoft Dynamics CRM database: in the XBintegrator Administrator Console, go to
<server> > Roles > <role> > Variables > XDCrm. In here, find a URL line:
XperiDo Nucleus: in the XBintegrator Administrator Console, go to <server> > Roles > <role> >
Variables > XDNucleus > DataBase. In here, find a URL line:
Now you should know which databases (the H2 ones) you can back up with the following steps.
Filename: doesn't matter really - but we advise to make it logical, such as xbibackup.sql. The extension
should be .sql.
Content: one line of code: BACKUP TO ‘<filename>.zip’ where you choose a name for the file and type
that instead of <filename>. You must include the path, for instance: BACKUP TO 'D:/Backup/xbi.zip'.
Filename: doesn't matter really - but we advise to make it logical, such as runbackup.bat. The extension
should be .bat.
Content: one line of code per SQL script: java -cp h2-<version>.jar org.h2.tools.RunScript -url
"<dburl>" -script <sqlfile> -user ""
<version>: the version of the H2 jar file, as found in the lib directory in the installdir. Here's an example:
h2-1.3.166.jar.
<dburl>: the URL of the database. Finding this for the XperiDo databases is explained above (in
Database types). For the XBi database, you can find this in the url tag in the Database tag of the
<installdir>/conf/xbconfig.xml file.
<sqlfile>: the SQL file that features the instruction you want to execute. These are the scripts you
created earlier.
Running the batch file will now create backups of your databases. You can schedule the execution of this batch
file with the Task Scheduler.