{"id":191953,"date":"2019-02-01T13:32:22","date_gmt":"2019-02-01T12:32:22","guid":{"rendered":"https:\/\/guide.jtl-software.com\/database\/"},"modified":"2024-03-21T10:18:06","modified_gmt":"2024-03-21T09:18:06","slug":"database","status":"publish","type":"page","link":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/","title":{"rendered":"Database"},"content":{"rendered":"<div class=\"wpb-content-wrapper\">[vc_row nospace=&#8221;1&#8243; min_height=&#8221;{&#8220;min_height&#8220;: &#8220;&#8220;, &#8220;min_height-xs&#8220;: &#8220;&#8220;, &#8220;min_height-sm&#8220;: &#8220;&#8220;, &#8220;min_height-md&#8220;: &#8220;&#8220;, &#8220;min_height-lg&#8220;: &#8220;&#8220;, &#8220;min_height-xl&#8220;: &#8220;&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221; utilities=&#8221;{&#8220;pb&#8220;: &#8220;5&#8220;}&#8221;][vc_column responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;12&#8220;}&#8221;]<style type=\"text\/css\">@media(max-width: 1200px) {.hero-card-69e266d9630c0{background: url(https:\/\/guide.jtl-software.com\/uploads\/Wawi-Datenbank-Hero.jpg) no-repeat center center \/ cover !important;}}@media(max-width: 992px) {.hero-card-69e266d9630c0{background: url(https:\/\/guide.jtl-software.com\/uploads\/Wawi-Datenbank-Hero-xs.jpg) no-repeat center center \/ cover !important;}}@media(max-width: 768px) {.hero-card-69e266d9630c0{background: url(https:\/\/guide.jtl-software.com\/uploads\/Wawi-Datenbank-Hero-xs.jpg) no-repeat center center \/ cover !important;}}<\/style><div class=\"border-wawi hero-card rounded rounded-bottom-left-0 rounded-bottom-right-0 border-bottom hero-card-69e266d9630c0\" style=\"background-image: url(https:\/\/guide.jtl-software.com\/uploads\/Wawi-Datenbank-Hero.jpg); background-position: center center; background-size: cover; background-repeat: no-repeat;\">\n\t<div class=\"hero-holder py-5 py-lg-6 px-5 px-lg-8\">\n\t\t<h1 class=\"text-shaftblue d-flex align-items-center hl-wawi\" id=\"managing-the-jtl-wawi-database\">Managing the JTL-Wawi database <span id='anchor-managing-the-jtl-wawi-database' data-href='#managing-the-jtl-wawi-database' class='far fa-link' data-anchor><\/span><\/h1><div class=\"pr-10 text-shaftblue\">\n\t<p>In the JTL-Wawi database administration you can back up your database, restore backups and increase database performance.<\/p>\n<\/div>\n\t<\/div>\n<\/div>\n<h2 class=\"mt-5 d-flex align-items-center hl-wawi\" id=\"how-to\"><span class=\"mr-3 fa-stack flex-shrink-0 fa-headline-0x\"><span class=\"far fa-circle fa-stack-2x text-wawi\"><\/span><span class=\"flex-shrink-0 fas fa-lightbulb text-wawi fa-stack-1x\"><\/span><\/span><span>How to<\/span> <span id='anchor-how-to' data-href='#how-to' class='far fa-link' data-anchor><\/span><\/h2><div class=\"border-defaultgray border-w-1 border card\">\n\t\t\t<div class=\"card-body p-4\">\n\t\t[vc_row_inner use_as_box=&#8221;1&#8243; min_height=&#8221;{&#8220;min_height&#8220;: &#8220;&#8220;, &#8220;min_height-xs&#8220;: &#8220;&#8220;, &#8220;min_height-sm&#8220;: &#8220;&#8220;, &#8220;min_height-md&#8220;: &#8220;&#8220;, &#8220;min_height-lg&#8220;: &#8220;&#8220;, &#8220;min_height-xl&#8220;: &#8220;&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221; utilities=&#8221;{&#8220;mb&#8220;: &#8220;5&#8220;, &#8220;pt&#8220;: &#8220;5&#8220;, &#8220;pr&#8220;: &#8220;5&#8220;, &#8220;pb&#8220;: &#8220;5&#8220;, &#8220;pl&#8220;: &#8220;5&#8220;}&#8221;][vc_column_inner width=&#8221;1\/2&#8243; responsive=&#8221;{&#8220;col&#8220;:&#8220;12&#8220;,&#8220;col-md&#8220;:&#8220;6&#8220;}&#8221;]<p class=\"d-flex align-items-center h6\">General<\/p><ul class=\"mb-5 list-reset ml-3 list-icons list-custom-square list-wawi\">\n\t<li >\n\t<a href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/changing-the-jtl-wawi-user\/\" title=\"Changing the JTL-Wawi user\">\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\tChanging the JTL-Wawi user\t<\/a><\/li><li >\n\t<a href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/starting-jtl-wawi-for-the-first-time\/\" title=\"Starting JTL-Wawi for the first time\">\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\tStarting JTL-Wawi for the first time\t<\/a><\/li><\/ul><p class=\"d-flex align-items-center h6\">Database administration<\/p><ul class=\"list-reset ml-3 list-icons list-custom-square list-wawi\">\n\t<li >\n\t<a href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/database-administration\/\" title=\"Database management\">\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\tDatabase management\t<\/a><\/li><li >\n\t<a href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/creating-a-data-backup-for-jtl-wawi\/\" target=\"_blank\" title=\"Creating a data backup for JTL-Wawi\" rel=\"noopener noreferrer\">\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\tCreating a data backup for JTL-Wawi\t<\/a><\/li><li >\n\t<a href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/restoring-a-database-backup\/\" target=\"_blank\" title=\"Restoring a database backup\" rel=\"noopener noreferrer\">\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\tRestoring a database backup\t<\/a><\/li><\/ul><p class=\"d-flex align-items-center hl-wawi h6\">Information on data protection<\/p><ul class=\"list-reset ml-3 list-icons list-custom-square list-wawi\">\n\t<li >\n\t<a href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/information-on-gdpr-in-jtl-wawi\/\" title=\"Processing of personal data according to the GDPR in JTL-Wawi\">\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\tProcessing of personal data according to the GDPR in JTL-Wawi\t<\/a><\/li><\/ul>[\/vc_column_inner][vc_column_inner width=&#8221;1\/2&#8243; responsive=&#8221;{&#8220;col&#8220;:&#8220;12&#8220;,&#8220;col-md&#8220;:&#8220;6&#8220;}&#8221;]<p class=\"d-flex align-items-center h6\">SQL database<\/p><ul class=\"mb-5 list-reset ml-3 list-icons list-custom-square list-wawi\">\n\t<li >\n\t<a href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/settings-for-database-users\/\" title=\"Settings for database users\">\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\tSettings for database users\t<\/a><\/li><li >\n\t<a href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/executing-sql-on-the-database\/\" title=\"Executing SQL on the database\">\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\tExecuting SQL on the database\t<\/a><\/li><\/ul><p class=\"d-flex align-items-center h6\">Hosting for JTL-Wawi?<\/p><ul class=\"list-reset ml-3 list-icons list-custom-square list-wawi\">\n\t<li >\n\t<a href=\"https:\/\/guide.jtl-software.com\/en\/jtl-hosting\/jtl-wawi-hosting-rdp\/\" title=\"JTL-Wawi Hosting\">\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\tJTL-Wawi Hosting\t<\/a><\/li><\/ul>[\/vc_column_inner][vc_column_inner responsive=&#8221;{&#8220;col&#8220;:&#8220;12&#8220;,&#8220;col-md&#8220;:&#8220;12&#8220;}&#8221;]<hr  \/>\n[\/vc_column_inner][vc_column_inner width=&#8221;1\/2&#8243; responsive=&#8221;{&#8220;col&#8220;:&#8220;12&#8220;,&#8220;col-md&#8220;:&#8220;6&#8220;}&#8221;]\t<p>The database administration opens when JTL-Wawi is started for the first time or can be accessed at any time via the menu item <span class=\"highlight\">Start &gt; Datenbank<\/span>\u00a0(Start &gt; Database).<\/p>\n\t<p>When JTL-Wawi is started for the first time, the necessary Microsoft SQL database is created automatically. Make sure that a Microsoft SQL Server has already been installed. We recommend that you use Microsoft SQL Server 2022. Read more on the topic here: <span style=\"color: #f68b25;\"><a style=\"color: #f68b25;\" href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/installation\/install-jtl-wawi-on-a-single-computer\/\">Installing JTL-Wawi on an individual workstation<\/a><\/span>.<\/p>\n[\/vc_column_inner][vc_column_inner width=&#8221;1\/2&#8243; responsive=&#8221;{&#8220;col&#8220;:&#8220;12&#8220;,&#8220;col-md&#8220;:&#8220;6&#8220;}&#8221;]\t<p>Once JTL-Wawi has been installed, you can perform various administrative tasks via the database administration. This includes database backup (export and import), database cleaning and performance optimisation. We will go over the individual points in this section of the documentation.<\/p>\n[\/vc_column_inner][\/vc_row_inner]\t<\/div>\n<\/div>[\/vc_column][\/vc_row]<\/div>","protected":false},"excerpt":{"rendered":"[vc_row nospace=&#8221;1&#8243; min_height=&#8221;{&#8220;min_height&#8220;: &#8220;&#8220;, &#8220;min_height-xs&#8220;: &#8220;&#8220;, &#8220;min_height-sm&#8220;: &#8220;&#8220;, &#8220;min_height-md&#8220;: &#8220;&#8220;, &#8220;min_height-lg&#8220;: &#8220;&#8220;, &#8220;min_height-xl&#8220;: &#8220;&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221; utilities=&#8221;{&#8220;pb&#8220;: &#8220;5&#8220;}&#8221;][vc_column <a href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/\">[&#8230;]<\/a>","protected":false},"author":2,"featured_media":0,"parent":192277,"menu_order":739,"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-191953","page","type-page","status-publish","hentry","search_categorie-jtl-wawi"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>JTL-Wawi database \u2013 Creating tenants, creating backups<\/title>\n<meta name=\"description\" content=\"Learn how to open the database administration in JTL-Wawi, manage users, create backups and restore them.\" \/>\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\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"JTL-Wawi database \u2013 Creating tenants, creating backups\" \/>\n<meta property=\"og:description\" content=\"Learn how to open the database administration in JTL-Wawi, manage users, create backups and restore them.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/\" \/>\n<meta property=\"og:site_name\" content=\"JTL-Guide\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-21T09:18:06+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=\"5 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\/\",\"url\":\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/\",\"name\":\"JTL-Wawi database \u2013 Creating tenants, creating backups\",\"isPartOf\":{\"@id\":\"https:\/\/guide.jtl-software.com\/en\/#website\"},\"datePublished\":\"2019-02-01T12:32:22+00:00\",\"dateModified\":\"2024-03-21T09:18:06+00:00\",\"description\":\"Learn how to open the database administration in JTL-Wawi, manage users, create backups and restore them.\",\"breadcrumb\":{\"@id\":\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/#breadcrumb\"},\"inLanguage\":\"en-en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"JTL-Wawi\",\"item\":\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Database\"}]},{\"@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":"JTL-Wawi database \u2013 Creating tenants, creating backups","description":"Learn how to open the database administration in JTL-Wawi, manage users, create backups and restore them.","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\/","og_locale":"en_US","og_type":"article","og_title":"JTL-Wawi database \u2013 Creating tenants, creating backups","og_description":"Learn how to open the database administration in JTL-Wawi, manage users, create backups and restore them.","og_url":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/","og_site_name":"JTL-Guide","article_modified_time":"2024-03-21T09:18:06+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/","url":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/","name":"JTL-Wawi database \u2013 Creating tenants, creating backups","isPartOf":{"@id":"https:\/\/guide.jtl-software.com\/en\/#website"},"datePublished":"2019-02-01T12:32:22+00:00","dateModified":"2024-03-21T09:18:06+00:00","description":"Learn how to open the database administration in JTL-Wawi, manage users, create backups and restore them.","breadcrumb":{"@id":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/#breadcrumb"},"inLanguage":"en-en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"JTL-Wawi","item":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/"},{"@type":"ListItem","position":2,"name":"Database"}]},{"@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\/191953","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\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/comments?post=191953"}],"version-history":[{"count":5,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/191953\/revisions"}],"predecessor-version":[{"id":250075,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/191953\/revisions\/250075"}],"up":[{"embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/192277"}],"wp:attachment":[{"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/media?parent=191953"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/tags?post=191953"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}