{"id":246280,"date":"2024-02-27T11:12:29","date_gmt":"2024-02-27T10:12:29","guid":{"rendered":"https:\/\/guide.jtl-software.com\/jtl-wawi\/database\/creating-a-data-backup-for-jtl-wawi\/"},"modified":"2024-03-21T10:20:11","modified_gmt":"2024-03-21T09:20:11","slug":"creating-a-data-backup-for-jtl-wawi","status":"publish","type":"page","link":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/creating-a-data-backup-for-jtl-wawi\/","title":{"rendered":"Creating a data backup for JTL-Wawi"},"content":{"rendered":"<div class=\"wpb-content-wrapper\">[vc_row][vc_column width=&#8221;1\/3&#8243; responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;order-md&#8220;: &#8220;1&#8220;, &#8220;col-lg&#8220;: &#8220;4&#8220;, &#8220;order-lg&#8220;: &#8220;12&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]<div id=\"toc\">\n\t<div class=\"card border-0 bg-rysywhite mt-0 mt-lg-5 mb-5 w-100\" data-toc-element>\n\t\t<div class=\"d-none d-lg-flex flex-column\">\n\t\t\t<span class=\"fa-layers mx-auto mt--4 fa-fw fa-3x text-shaftblue\">\n\t\t\t\t<span class=\"fas fa-circle\"><\/span>\n\t\t\t\t<span class=\"fas fa-inverse fa-list-ul\" data-fa-transform=\"shrink-8\"><\/span>\n\t\t\t<\/span>\n\t\t\t<span class=\"font-weight-bold text-shaftblue text-center h5 mt-3 mb-0\">Contents<\/span>\n\t\t<\/div>\n\t\t<div class=\"d-block d-lg-none\">\n\t\t\t<a class=\"text-decoration-none card-header-link collapsed\" data-toggle=\"collapse\" href=\"#collapse-toc\" aria-expanded=\"false\" aria-controls=\"collapse-toc\">\n\t\t\t\t<div class=\"card-header d-flex bg-white align-items-center\" role=\"tab\" id=\"heading-toc\">\n\t\t\t\t\t<span class=\"h4 mb-0 d-flex align-items-center\">\n\t\t\t\t\t\t<span class=\"fa-layers fa-fw fa-2x mr-2 text-shaftblue\">\n\t\t\t\t\t\t\t<span class=\"fas fa-circle\"><\/span>\n\t\t\t\t\t\t\t<span class=\"fas fa-inverse fa-list-ul\" data-fa-transform=\"shrink-8\"><\/span>\n\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span>Contents<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<span class=\"flex-shrink-0 ml-auto fas fa-caret-down text-gray\"><\/span>\n\t\t\t\t<\/div>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t<div id=\"collapse-toc\" class=\"collapse show\" data-parent=\"#toc\" role=\"tabpanel\" aria-labelledby=\"heading-toc\">\n\t\t\t<div class=\"card-body p-4 table-of-content\">\n\t\t\t\t<ul data-toc-headings=\"h2,h3\" data-toc class=\"list-wawi\"><\/ul>\n\t\t\t<\/div>\n\t    <\/div>\n\t<\/div>\n<\/div><div class=\"sticky-top d-none d-xs-none d-sm-none d-md-none d-lg-block d-xl-block card\">\n\t\t\t<div class=\"card-body p-4\">\n\t\t<p class=\"mb-xs--4 d-flex align-items-center hl-wawi h3\">Video<\/p><p class=\"d-flex align-items-center hl-wawi h6\">Creating a database backup<\/p><div class=\"mb-3 embed-responsive embed-responsive-16by9\">\n\t\t\t<div class=\"embed-responsive-item\" data-youtubeCover=\"{&quot;player&quot;:{&quot;videoID&quot;:&quot;JMS_zb2WtH0&quot;}}\">\n\t\t\t\t\t\t\t<div class=\"cover max poster\">\n\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/youtube-thumbs\/JMS_zb2WtH0-maxresdefault.jpg\" width=\"560\" height=\"315\">\n\t\t\t\t\t<span class=\"fab fa-youtube video-icon\"><\/span>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t<\/div>\n\t<p>In this video we explain how to back up your JTL-Wawi database.<\/p>\n\t<\/div>\n<\/div>[\/vc_column][vc_column responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;8&#8220;, &#8220;order-md&#8220;: &#8220;12&#8220;, &#8220;order-lg&#8220;: &#8220;1&#8220;}&#8221; width=&#8221;2\/3&#8243; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]<h1 class=\"d-flex align-items-center hl-wawi\" id=\"creating-a-data-backup-for-jtl-wawi\">Creating a data backup for JTL-Wawi <span id='anchor-creating-a-data-backup-for-jtl-wawi' data-href='#creating-a-data-backup-for-jtl-wawi' class='far fa-link' data-anchor><\/span><\/h1><div class=\"custom-box\">\n\t<div class=\"d-flex align-items-center mb-4\">\n\t\t\t\t\t\t\t<span class=\"mr-3 fa-stack flex-shrink-0 fa-1x\">\n\t\t\t<span class=\"fas fa-circle fa-stack-2x text-shaftblue\"><\/span>\n\t\t\t\t\t<span class=\"flex-shrink-0 fas fa-clipboard-list text-white fa-stack-1x\"><\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\n\t\t\n\t\t<h3 class=\"mb-0 \" id=\"your-task-initial-situation\">Your task\/initial situation <span id='anchor-your-task-initial-situation' data-href='#your-task-initial-situation' class='far fa-link' data-anchor><\/span><\/h3>\t<\/div>\n\t<div class=\"box-content\">\n\t\t<strong>Case A &#8211; Data backup:<\/strong>&nbsp;You would like to set up a regular database backup for JTL-Wawi and learn how to create a backup of the database manually and automatically.\n\n<strong>Case B &#8211; Creating a backup for transfer to third parties\/other operating environments:&nbsp;<\/strong>You would like to transfer a database backup to colleagues or external service providers. Read more on this topic here: <span style=\"color: #f68b25;\"><a style=\"color: #f68b25;\" href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/restoring-a-database-backup\/\">Restoring a database backup<\/a><\/span>.\t<\/div>\n<\/div>\n<h2 class=\"d-flex align-items-center hl-wawi\" id=\"choosing-a-backup-strategy\">Choosing a backup strategy <span id='anchor-choosing-a-backup-strategy' data-href='#choosing-a-backup-strategy' class='far fa-link' data-anchor><\/span><\/h2>\t<p>We recommend that you start thinking about a backup strategy early on. There are several layers to a backup strategy, and it can be more or less complex depending on the size of your business and order volume. Always ask yourself the following questions:<\/p>\n<ul class=\"mb--1 list-reset ml-3 list-icons list-custom-square list-wawi\">\n\t<li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t<b>How often should I back up my data?<\/b>\t<\/li><\/ul><div class=\"ml-4\">\n\t<p>For a smaller company, one backup per day for the productive tenant of JTL-Wawi is sufficient. For example, one regular backup in the evening. The productive tenant holds the dataset of the productive operating environment in your company. In general, smaller companies only use one tenant. For larger businesses, shorter intervals might be a better option. A good way to determine the right interval is to ask yourself: How much data would I have to reconstruct if I restored the last backup?<\/p>\n<\/div>\n<ul class=\"mb--1 list-reset ml-3 list-icons list-custom-square list-wawi\">\n\t<li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t<b>How do I back up my data?<\/b>\t<\/li><\/ul><div class=\"ml-4\">\n\t<p>You can perform backups manually or automatically. The possible automation options depend on your SQL server version and, if applicable, the additional software used. If you back up your data manually, you need to ensure that there is a designated employee who always performs the update, and another who can cover this role in their absence. We generally recommend automating the backup.<\/p>\n<\/div>\n<ul class=\"mb--1 list-reset ml-3 list-icons list-custom-square list-wawi\">\n\t<li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t<b>Where do I store my backups?<\/b>\t<\/li><\/ul><div class=\"ml-4\">\n\t<p>You should never store the backups on the same hard drive as the original database (which is the server). Ideally, the backups are stored on a different server at a different location than the database server. This helps to avoid the destruction of both the original and the backup database, for example in case of a fire.<\/p>\n<\/div>\n<div class=\"media-object media-object-border d-flex align-items-top\">\n\t\n\t\t\n\t\t<span class=\"mt-1 mr-3 flex-shrink-0 far fa-info-circle fa-2x columnsize-fa-2x text-wawi\"><\/span>\n\t\t\t<span class=\"media-content border-wawi\">\n\t\n\t\t\t<span style=\"color: #f68b25;\"><b>Please note:<\/b><\/span> You should check on a regular basis whether your backups are being created correctly. The easiest way to do this is to restore a backup. Use a test instance of Microsoft SQL Server which is run, for example, on a different computer.\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n<ul class=\"mb--1 list-reset ml-3 list-icons list-custom-square list-wawi\">\n\t<li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t<b>How many backups should I keep?<\/b>\t<\/li><\/ul><div class=\"ml-4\">\n\t<p>If there is unlimited storage space, you can keep every backup. However, it is usually sufficient to keep only the last few backups. For example, the backups of the last two weeks. In addition, we recommend archiving a backup separately, e.g. once a month. This is useful if older data needs to be reconstructed.<\/p>\n<\/div>\n<ul class=\"mb--1 list-reset ml-3 list-icons list-custom-square list-wawi\">\n\t<li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t<b>Creating backups before high-risk activities<\/b>\t<\/li><\/ul><div class=\"ml-4\">\n\t<p>There are activities that can pose a significant risk to the data integrity. These are all actions in which large amounts of data can be changed at once. These typically include:<\/p>\n<\/div>\n<div class=\"ml-4\">\n\t<p><strong>Updating to a different version:<\/strong> During a version update, some of the data structures can be changed significantly for technical reasons. Before updating JTL-Wawi, you should always perform a data backup. With newer versions of JTL-Wawi, a backup is carried out automatically during the update process as long as you do not deactivate this option.<\/p>\n<\/div>\n<hr  \/>\n<div class=\"ml-4\">\n\t<p><strong>Adding new systems with data synchronisation:<\/strong> You should always carry out a data backup before activating a new system that writes data into your productive operating environment. Many systems do not only read large amounts of data from JTL-Wawi, but also send just as much data back to JTL-Wawi and thus significantly change the database. This group includes all data synchronisations with online shops, cash register systems, marketplaces, the JTL-Fulfillment Network, the JTL-Vouchers solution, the JTL-Customer Centre\/Customer Account and all third-party systems connected via API that have a write access to JTL-Wawi.<\/p>\n<\/div>\n<hr  \/>\n<div class=\"ml-4\">\n\t<p><strong>Changing large amounts of data with JTL-DataTransfer<\/strong>: JTL-Wawi&#8217;s import\/export tool is a powerful tool that can quickly change large amounts of data. However, if configured incorrectly, faulty changes are made on a large scale. You should always carry out a data backup before each import with JTL-DataTransfer, especially if you are not very familiar with the tool yet.<\/p>\n<\/div>\n<div class=\"media-object media-object-border d-flex align-items-top\">\n\t\n\t\t\n\t\t<span class=\"mt-1 mr-3 flex-shrink-0 far fa-info-circle fa-2x columnsize-fa-2x text-wawi\"><\/span>\n\t\t\t<span class=\"media-content border-wawi\">\n\t\n\t\t\t<span style=\"color: #f68b25;\"><b>Please note:<\/b><\/span> A connected system landscape consisting of other systems with their own data storage in addition to JTL-Wawi can only be considered fully secured if a data backup is created for each of the systems at around the same time. Exceptions are systems that only import data from a leading system.\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n<ul class=\"mb--1 list-reset ml-3 list-icons list-custom-square list-wawi\">\n\t<li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t<b>How do I prepare backups for sharing?<\/b>\t<\/li><\/ul><div class=\"ml-4\">\n\t<p>With the usual data backup, the current data status is backed up and set aside for emergencies. If an emergency occurs and you decide to restore your data from a data backup, the database backup will be restored in the productive operating environment. Another purpose of a backup is to pass it to third parties. For example to reproduce errors in support cases, to prepare updates in a staging environment or as a template of true to original data as part of a development project, e.g. a new online presence or setting up JTL-WMS.<\/p>\n<\/div>\n<div class=\"media-object media-object-border d-flex align-items-top\">\n\t\n\t\t\n\t\t<span class=\"mt-1 mr-3 flex-shrink-0 far fa-exclamation-circle fa-2x columnsize-fa-2x text-wawi\"><\/span>\n\t\t\t<span class=\"media-content border-wawi\">\n\t\n\t\t\t<span style=\"color: #f68b25;\"><b>Attention:<\/b><\/span> If you pass on data to third parties, please make sure that this copy of the data does not affect your productive operation! To do this, it is necessary to remove any configuration for data synchronisation from your database backup. Read more on this topic here: <span style=\"color: #f68b25;\"><a style=\"color: #f68b25;\" href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/restoring-a-database-backup\/\">Restoring a database backup<\/a><\/span>.\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n<h2 class=\"d-flex align-items-center hl-wawi\" id=\"manually-performing-a-jtl-wawi-backup\">Manually performing a JTL-Wawi backup <span id='anchor-manually-performing-a-jtl-wawi-backup' data-href='#manually-performing-a-jtl-wawi-backup' class='far fa-link' data-anchor><\/span><\/h2><ol start=\"1\" class=\"mb-5 list-reset step mb-5 list-wawi normal-step\">\n\t<li class=\"media-single-line\">\n\tOpen the database administration of JTL-Wawi via <span class=\"highlight\">Start &gt; Database<\/span>.<\/li><li class=\"media-single-line\">\n\tLog in with your SQL server user data.<\/li><\/ol>\t\t\t\t\t\t<div data-gallery>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-datenbank-001-backup-erstellen-anmeldung.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-datenbank-001-backup-erstellen-anmeldung.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-datenbank-001-backup-erstellen-anmeldung.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-datenbank-001-backup-erstellen-anmeldung-1024x675.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-datenbank-001-backup-erstellen-anmeldung-768x506.png 640w\" width=\"1316\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"867\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/Jtl-wawi-datenbank-001-backup-erstellen-anmeldung.png&quot;,&quot;w&quot;:1316,&quot;h&quot;:867}\" class=\"mb-5 img-fluid mb-5\">\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<ol start=\"3\" class=\"mb-5 list-reset step mb-5 list-wawi normal-step\">\n\t<li >\n\tSelect the tenant for which you want to create the backup. In the <span class=\"highlight\">Editing tenants<\/span> section, click <span class=\"highlight\">Database export<\/span>.<\/li><\/ol><div class=\"media-object media-object-border d-flex align-items-top\">\n\t\n\t\t\n\t\t<span class=\"mt-1 mr-3 flex-shrink-0 far fa-info-circle fa-2x columnsize-fa-2x text-wawi\"><\/span>\n\t\t\t<span class=\"media-content border-wawi\">\n\t\n\t\t\t<span style=\"color: #f68b25;\"><b>Please note:<\/b><\/span> If you want to share the database backup with third parties or use it for any purpose other than backup-only, make sure to remove all synchronisation configurations. Read more on this topic here: <span style=\"color: #f68b25;\"><a style=\"color: #f68b25;\" href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/restoring-a-database-backup\/\">Restoring a database backup<\/a><\/span>.\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n\t\t\t\t\t\t<div data-gallery>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-datenbankverwaltung-Datenbankexport.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-datenbankverwaltung-Datenbankexport.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-datenbankverwaltung-Datenbankexport.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-datenbankverwaltung-Datenbankexport-1024x536.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-datenbankverwaltung-Datenbankexport-768x402.png 640w\" width=\"1426\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"746\" alt=\"Jtl Wawi Datenbankverwaltung Datenbankexport\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/Jtl-wawi-datenbankverwaltung-Datenbankexport.png&quot;,&quot;w&quot;:1426,&quot;h&quot;:746}\" class=\"mb-5 img-fluid mb-5\">\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<ol start=\"4\" class=\"mb-5 list-reset step mb-5 list-wawi normal-step\">\n\t<li >\n\tSelect a storage location for your backup and give it a name. If you do not choose a different storage path, the default directory will be used: \u201cc:\\programme\\microsoft sql server\\instanz\\backup\u201d.<\/li><\/ol>\t<p><b>Reorganise and create new indices before the backup:<\/b> Here you can specify whether the database indices should be optimised before the backup. We recommend activating this option to prevent problems when restoringa backup.<\/p>\n\t\t\t\t\t\t<div data-gallery>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-datenbankverwaltung-DB-Export-speicherort-ausw\u00e4hlen.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-datenbankverwaltung-DB-Export-speicherort-ausw\u00e4hlen.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-datenbankverwaltung-DB-Export-speicherort-ausw\u00e4hlen.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-datenbankverwaltung-DB-Export-speicherort-ausw\u00e4hlen-1024x605.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-datenbankverwaltung-DB-Export-speicherort-ausw\u00e4hlen-768x453.png 640w\" width=\"1426\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"842\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/Jtl-wawi-datenbankverwaltung-DB-Export-speicherort-ausw\\u00e4hlen.png&quot;,&quot;w&quot;:1426,&quot;h&quot;:842}\" class=\"mb-5 img-fluid mb-5\">\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<ol start=\"5\" class=\"mb-5 list-reset step mb-5 list-wawi normal-step\">\n\t<li >\n\tClick <span class=\"highlight\">Start<\/span>. If a backup was successful, a database backup will have been created in the form of a .bak file.<\/li><\/ol><div class=\"media-object media-object-border d-flex align-items-top\">\n\t\n\t\t\n\t\t<span class=\"mt-1 mr-3 flex-shrink-0 far fa-info-circle fa-2x columnsize-fa-2x text-wawi\"><\/span>\n\t\t\t<span class=\"media-content border-wawi\">\n\t\n\t\t\t<span style=\"color: #f68b25;\"><strong>Please note:<\/strong><\/span> If you change the path of the backup, the selected directory must have sufficient rights. Otherwise, the backup cannot be created. The default backup directory \u201c<span class=\"highlight\">c:\\programme\\microsoft sql server\\instanz\\backup<\/span>\u201c always has sufficient rights.\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n\t<p>The backup can be restored at any time via the <span class=\"highlight\">DB import<\/span> option.<\/p>\n\t<p>For further information on importing backups, please read:<\/p>\n<div class=\"mb-5 btn-helper m--1\">\n\t<a href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/restoring-a-database-backup\/\" title=\"Restoring backups\" class=\"btn-wawi btn m-1\">\n\t\tRestoring backups<\/a><\/div><h2 class=\"d-flex align-items-center hl-wawi\" id=\"automatically-backing-up-jtl-wawi-data\">Automatically backing up JTL-Wawi data <span id='anchor-automatically-backing-up-jtl-wawi-data' data-href='#automatically-backing-up-jtl-wawi-data' class='far fa-link' data-anchor><\/span><\/h2>\t<p>If you use at least a standard licence for Microsoft SQL Server, you can automate the backup in SQL Server Management Studio. The automatic backup is then executed on the server by the server agent. Read our <span style=\"color: #ff9900;\"><a class=\"JTL-Wawi-color\" style=\"color: #ff9900;\" title=\"Tips for SQL server maintenance\" href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/installation\/tips-for-sql-server-maintenance\/#sicherung-automatisieren\">SQL server tips<\/a><\/span>.<\/p>\n\t<p>For users of Microsoft SQL Server Express, there is a workaround for the automatic database backup (main database and\/or tenant databases) in the form of a scheduled Windows task. This comprises the daily creation of a new backup file in the backup directory. This is also possible without using additional tenants. The default database is called \u201ceazybusiness\u201d. This means that in the code below, the respective lines for the tenants would be missing.<\/p>\n\t<p>JTL-Wawi uses the following names for databases:<\/p>\n<ul class=\"mb-5 list-reset ml-3 list-icons list-custom-square list-wawi\">\n\t<li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t<b>eazybusiness<\/b>: Main database. This database contains all the information on tenants (the database administration stores data here) and on the first tenant (main tenant). This database is created automatically after installing JTL-Wawi.\t<\/li><li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t<b>tenant_x<\/b>: Tenant databases. Every additional tenant has their own database. The main database \u201ceazybusiness\u201d notifies JTL-Wawi that additional tenants exist. The tenant databases named <span class=\"highlight\">tenant_x<\/span> are created automatically when a new tenant is added.\t<\/li><\/ul>\t<p>Please note that a backup of the main database can only be imported by JTL-Wawi as a main database.<\/p>\n\t<p><b>.bat file:<\/b><\/p>\n\t<p>The respective backup folders must be created beforehand, e.g. d:\\backup\\eazybusiness\\tenant_1, etc.<\/p>\n\t<p>tenant_1 to 6 are only examples for tenant databases.<\/p>\n\t<p>When there are fewer tenants, the code can be shortened after osql.exe to the actual number of existing tenants.<\/p>\n<div data-codecopy=\"1\" class=\"media-item\">\n\t<div class=\"media-object\">\n\t\t<span class=\"fa-stack fa-stacksize-2x\">\n\t\t\t<span class=\"far fa-circle fa-stack-2x text-wawi\"><\/span>\n\t\t\t<span class=\"fas fa-code fa-stack-1x text-wawi\"><\/span>\n\t\t<\/span>\n\t<\/div>\n\t<div class=\"media-content\">\n\t\t<pre><code class=\"rounded bg-rysywhite p-5 \">@echo off\nosql.exe -S (local)\\JTLWAWI -U sa -P sa04jT14 -Q &quot;BACKUP DATABASE eazybusiness TO DISK = &#039;d:\\backup\\db\\%date%.bak&#039;&quot;\nosql.exe -S (local)\\JTLWAWI -U sa -P sa04jT14 -Q &quot;BACKUP DATABASE mandant_1 TO DISK =&#039;d:\\backup\\mandant_1\\%date%.bak&#039;&quot;\nosql.exe -S (local)\\JTLWAWI -U sa -P sa04jT14 -Q &quot;BACKUP DATABASE mandant_2 TO DISK = &#039;d:\\backup\\mandant_2\\%date%.bak&#039;&quot;\nosql.exe -S (local)\\JTLWAWI -U sa -P sa04jT14 -Q &quot;BACKUP DATABASE mandant_3 TO DISK = &#039;d:\\backup\\mandant_3\\%date%.bak&#039;&quot;\nosql.exe -S (local)\\JTLWAWI -U sa -P sa04jT14 -Q &quot;BACKUP DATABASE mandant_4 TO DISK = &#039;d:\\backup\\mandant_4\\%date%.bak&#039;&quot;\nosql.exe -S (local)\\JTLWAWI -U sa -P sa04jT14 -Q &quot;BACKUP DATABASE mandant_5 TO DISK = &#039;d:\\backup\\mandant_5\\%date%.bak&#039;&quot;\nosql.exe -S (local)\\JTLWAWI -U sa -P sa04jT14 -Q &quot;BACKUP DATABASE mandant_6 TO DISK = &#039;d:\\backup\\mandant_6\\%date%.bak&#039;&quot;<\/code><\/pre>\n\t\t<span class=\"fas fa-paste text-shaftblue copy-btn\"><\/span>\n\t<\/div>\n<\/div>\n\n\t<p><b>Attention:<\/b> Adjust the path <i>D:\\Backup\\eazybusiness\\<\/i> for your system. The backup files will be saved to this folder. Try performing a manual test backup of the JTL-Wawi database and saving it to the respective folder first. If this is not possible and an error message is generated, please read the troubleshooting page: <span style=\"color: #f68b25;\"><a class=\"JTL-Wawi-color\" style=\"color: #f68b25;\" title=\"Database FAQ\" href=\"https:\/\/guide.jtl-software.com\/jtl-wawi\/datenbank\/datenbank-faq\/\/#backup-laesst-sich-nicht-erstellen\">Backup not possible<\/a><\/span>. If you have changed the database password, use your changed password instead of \u201csa04jT14\u201d.<\/p>\n<div data-codecopy=\"1\" class=\"media-item\">\n\t<div class=\"media-object\">\n\t\t<span class=\"fa-stack fa-stacksize-2x\">\n\t\t\t<span class=\"far fa-circle fa-stack-2x text-wawi\"><\/span>\n\t\t\t<span class=\"fas fa-code fa-stack-1x text-wawi\"><\/span>\n\t\t<\/span>\n\t<\/div>\n\t<div class=\"media-content\">\n\t\t<pre><code class=\"rounded bg-rysywhite p-5 \">@echo off\nosql.exe -D eazy -U sa -P sa04jT14 -Q &quot;BACKUP DATABASE eazybusiness TO DISK = &#039;d:\\backup\\db\\%date%.bak&#039;&quot;<\/code><\/pre>\n\t\t<span class=\"fas fa-paste text-shaftblue copy-btn\"><\/span>\n\t<\/div>\n<\/div>\n\n<div class=\"media-object media-object-border d-flex align-items-top\">\n\t\n\t\t\n\t\t<span class=\"mt-1 mr-3 flex-shrink-0 far fa-exclamation-circle fa-2x columnsize-fa-2x text-wawi\"><\/span>\n\t\t\t<span class=\"media-content border-wawi\">\n\t\n\t\t\t<span style=\"color: #f68b25;\"><b>Attention:<\/b><\/span> Adjust the path <i>d:\\backup\\eazybusiness\\db\\<\/i> for your system. The backup files will be saved to this folder. If you changed the database&#8217;s password, use the changed password instead of \u201csa04jT14\u201d.\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n\t<p>The tenant backup data can be restored via the <span style=\"color: #f68b25;\"><a class=\"JTL-Wawi-color\" style=\"color: #f68b25;\" title=\"General information on tenant management\" href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/installation\/general-information-on-company-management\/\">Database administration<\/a><\/span>.<\/p>\n<div class=\"sticky-top d-block d-xs-block d-sm-block d-md-block d-lg-none d-xl-none card\">\n\t\t\t<div class=\"card-body p-4\">\n\t\t<p class=\"mb-xs--4 d-flex align-items-center hl-wawi h3\">Video<\/p><p class=\"d-flex align-items-center hl-wawi h6\">Creating a database backup<\/p><div class=\"mb-3 embed-responsive embed-responsive-16by9\">\n\t\t\t<div class=\"embed-responsive-item\" data-youtubeCover=\"{&quot;player&quot;:{&quot;videoID&quot;:&quot;JMS_zb2WtH0&quot;}}\">\n\t\t\t\t\t\t\t<div class=\"cover max poster\">\n\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/youtube-thumbs\/JMS_zb2WtH0-maxresdefault.jpg\" width=\"560\" height=\"315\">\n\t\t\t\t\t<span class=\"fab fa-youtube video-icon\"><\/span>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t<\/div>\n\t<p>In this video we explain how to back up your JTL-Wawi database.<\/p>\n\t<\/div>\n<\/div><div class=\"card\">\n\t\t\t<span class=\"fa-layers mx-auto mt--4 fa-fw fa-3x text-wawi\">\n\t\t\t<span class=\"fas fa-circle\"><\/span>\n\t\t\t<span data-fa-transform=\"shrink-8\" class=\"fas fa-link fa-inverse\"><\/span>\n\t\t<\/span>\n\t\t\t<div class=\"card-body p-4\">\n\t\t<p class=\"d-flex align-items-center hl-wawi h4\">Related topics<\/p>\n<ul class=\"list-reset list-icons list-custom-square list-wawi\">\n\t\t\t\t\t\t<li>\n\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/database-administration\/\" title=\"Database management\">\n\t\t\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t\t\t\tDatabase management\t\t\t\t<\/a>\n\t\t\t<\/li>\n\t\t\t\t\t<li>\n\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/restoring-a-database-backup\/\" title=\"Restoring a database backup\">\n\t\t\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t\t\t\tRestoring a database backup\t\t\t\t<\/a>\n\t\t\t<\/li>\n\t\t\t\t<\/ul>\t<\/div>\n<\/div>[\/vc_column][\/vc_row]<\/div>","protected":false},"excerpt":{"rendered":"[vc_row][vc_column width=&#8221;1\/3&#8243; responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;order-md&#8220;: &#8220;1&#8220;, &#8220;col-lg&#8220;: &#8220;4&#8220;, &#8220;order-lg&#8220;: &#8220;12&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;][\/vc_column][vc_column responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;8&#8220;, &#8220;order-md&#8220;: &#8220;12&#8220;, <a href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/restoring-a-database-backup\/\">[&#8230;]<\/a>","protected":false},"author":16,"featured_media":0,"parent":191953,"menu_order":546,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_relevanssi_hide_post":"","_relevanssi_hide_content":"","_relevanssi_pin_for_all":"","_relevanssi_pin_keywords":"","_relevanssi_unpin_keywords":"","_relevanssi_related_keywords":"","_relevanssi_related_include_ids":"","_relevanssi_related_exclude_ids":"","_relevanssi_related_no_append":"","_relevanssi_related_not_related":"","_relevanssi_related_posts":"","_relevanssi_noindex_reason":"","footnotes":""},"tags":[],"class_list":["post-246280","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Creating a data backup for JTL-Wawi &#8211; JTL-Guide<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/creating-a-data-backup-for-jtl-wawi\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating a data backup for JTL-Wawi &#8211; JTL-Guide\" \/>\n<meta property=\"og:description\" content=\"[vc_row][vc_column width=&#8221;1\/3&#8243; responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;order-md&#8220;: &#8220;1&#8220;, &#8220;col-lg&#8220;: &#8220;4&#8220;, &#8220;order-lg&#8220;: &#8220;12&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;][\/vc_column][vc_column responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;8&#8220;, &#8220;order-md&#8220;: &#8220;12&#8220;, [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/creating-a-data-backup-for-jtl-wawi\/\" \/>\n<meta property=\"og:site_name\" content=\"JTL-Guide\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-21T09:20:11+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"15 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/creating-a-data-backup-for-jtl-wawi\/\",\"url\":\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/creating-a-data-backup-for-jtl-wawi\/\",\"name\":\"Creating a data backup for JTL-Wawi &#8211; JTL-Guide\",\"isPartOf\":{\"@id\":\"https:\/\/guide.jtl-software.com\/en\/#website\"},\"datePublished\":\"2024-02-27T10:12:29+00:00\",\"dateModified\":\"2024-03-21T09:20:11+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/creating-a-data-backup-for-jtl-wawi\/#breadcrumb\"},\"inLanguage\":\"en-en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/creating-a-data-backup-for-jtl-wawi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/creating-a-data-backup-for-jtl-wawi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"JTL-Wawi\",\"item\":\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Database\",\"item\":\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/datenbank\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Creating a data backup for JTL-Wawi\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/guide.jtl-software.com\/en\/#website\",\"url\":\"https:\/\/guide.jtl-software.com\/en\/\",\"name\":\"JTL-Guide\",\"description\":\"Dokumentation f\u00fcr die gesamte Produktfamilie von JTL\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/guide.jtl-software.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-en\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Creating a data backup for JTL-Wawi &#8211; JTL-Guide","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/creating-a-data-backup-for-jtl-wawi\/","og_locale":"en_US","og_type":"article","og_title":"Creating a data backup for JTL-Wawi &#8211; JTL-Guide","og_description":"[vc_row][vc_column width=&#8221;1\/3&#8243; responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;order-md&#8220;: &#8220;1&#8220;, &#8220;col-lg&#8220;: &#8220;4&#8220;, &#8220;order-lg&#8220;: &#8220;12&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;][\/vc_column][vc_column responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;8&#8220;, &#8220;order-md&#8220;: &#8220;12&#8220;, [...]","og_url":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/creating-a-data-backup-for-jtl-wawi\/","og_site_name":"JTL-Guide","article_modified_time":"2024-03-21T09:20:11+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"15 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/creating-a-data-backup-for-jtl-wawi\/","url":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/creating-a-data-backup-for-jtl-wawi\/","name":"Creating a data backup for JTL-Wawi &#8211; JTL-Guide","isPartOf":{"@id":"https:\/\/guide.jtl-software.com\/en\/#website"},"datePublished":"2024-02-27T10:12:29+00:00","dateModified":"2024-03-21T09:20:11+00:00","breadcrumb":{"@id":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/creating-a-data-backup-for-jtl-wawi\/#breadcrumb"},"inLanguage":"en-en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/creating-a-data-backup-for-jtl-wawi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/creating-a-data-backup-for-jtl-wawi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"JTL-Wawi","item":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/"},{"@type":"ListItem","position":2,"name":"Database","item":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/datenbank\/"},{"@type":"ListItem","position":3,"name":"Creating a data backup for JTL-Wawi"}]},{"@type":"WebSite","@id":"https:\/\/guide.jtl-software.com\/en\/#website","url":"https:\/\/guide.jtl-software.com\/en\/","name":"JTL-Guide","description":"Dokumentation f\u00fcr die gesamte Produktfamilie von JTL","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/guide.jtl-software.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-en"}]}},"_links":{"self":[{"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/246280","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/comments?post=246280"}],"version-history":[{"count":5,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/246280\/revisions"}],"predecessor-version":[{"id":250189,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/246280\/revisions\/250189"}],"up":[{"embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/191953"}],"wp:attachment":[{"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/media?parent=246280"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/tags?post=246280"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}