{"id":192043,"date":"2018-12-19T09:36:49","date_gmt":"2018-12-19T08:36:49","guid":{"rendered":"https:\/\/guide.jtl-software.com\/tips-for-sql-server-maintenance\/"},"modified":"2023-06-14T14:55:51","modified_gmt":"2023-06-14T12:55:51","slug":"tips-for-sql-server-maintenance","status":"publish","type":"page","link":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/installation\/tips-for-sql-server-maintenance\/","title":{"rendered":"Tips for SQL server maintenance"},"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=\"d-print-none 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=\"d-flex align-items-center hl-wawi h3\">Video<\/p><p class=\"d-flex align-items-center hl-wawi h6\">SQL Server performance optimisation<\/p><div class=\"embed-responsive embed-responsive-16by9\">\n\t\t\t<div class=\"embed-responsive-item\" data-youtubeCover=\"{&quot;player&quot;:{&quot;videoID&quot;:&quot;lXDvTaM56Q0&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\/lXDvTaM56Q0-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 you will learn how to improve the performance of your SQL Server with the DB ConfigTool.<\/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\" id=\"tips-for-sql-server-maintenance\">Tips for SQL server maintenance <span id='anchor-tips-for-sql-server-maintenance' data-href='#tips-for-sql-server-maintenance' 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\tYou have set up an SQL server for JTL-Wawi and are working with it. We recommend that you carry out server maintenance yourself, since the SQL server is a separate external product and not part of JTL-Wawi. In the long run, signs of wear can lead to serious, maybe even irreversible damage to the software. In coordination with our Support Team, we identified the three most common issues that our customers have experienced with the Microsoft server technology.\t<\/div>\n<\/div>\n<h2 class=\"d-flex align-items-center\" id=\"setting-up-a-database-backup\">Setting up a database backup <span id='anchor-setting-up-a-database-backup' data-href='#setting-up-a-database-backup' class='far fa-link' data-anchor><\/span><\/h2>\t<p>It is always possible that a database server cannot be restarted due to a problem. To prevent a loss of data relating to sales orders, customers and items, you should regularly back up your server. We recommend backing up your server at least once a day. The storage location for the backup should be different from the server location to prevent the backup from being destroyed along with the original, e.g. in a fire.<\/p>\n<h3 class=\"d-flex align-items-center\" id=\"manual-backup\">Manual backup <span id='anchor-manual-backup' data-href='#manual-backup' class='far fa-link' data-anchor><\/span><\/h3>\t<p>This is how you perform a manual backup:<\/p>\n<ol start=\"1\" class=\"list-reset step mb-5 list-wawi normal-step\">\n\t<li class=\"media-single-line\">\n\tIn JTL-Wawi, open the database administration under\u00a0<span class=\"highlight\">Start &gt; Datenbank<\/span>\u00a0(Start &gt; Database).<\/li><li >\n\tLog in to the database administration and choose the Mandant (Tenant) for which you want to perform a backup.<\/li><li class=\"media-single-line\">\n\tClick\u00a0<span class=\"highlight\">DB-Export<\/span>.<\/li><li >\n\tIf necessary, select a\u00a0<span class=\"highlight\">Speicherort<\/span>\u00a0\u00a0(Storage location) and a\u00a0<span class=\"highlight\">Dateiname<\/span>\u00a0\u00a0(File name) and click\u00a0<span class=\"highlight\">Start<\/span>.\r\n\r\nThe database backup will now be created.<\/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-sql-server-010-manuelle-sicherung-starten.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-sql-server-010-manuelle-sicherung-starten.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-server-010-manuelle-sicherung-starten.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-server-010-manuelle-sicherung-starten-1024x605.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-server-010-manuelle-sicherung-starten-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-sql-server-010-manuelle-sicherung-starten.png&quot;,&quot;w&quot;:1426,&quot;h&quot;:842}\" class=\"border-gray border-w-1 border 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<h3 class=\"d-flex align-items-center\" id=\"automated-backup\">Automated backup <span id='anchor-automated-backup' data-href='#automated-backup' class='far fa-link' data-anchor><\/span><\/h3>\t<p>Users of the Standard, Enterprise or Web Editions can download a script on\u00a0<a class=\"external free\" href=\"https:\/\/ola.hallengren.com\/\"  target='_blank' rel='noopener noreferrer' rel=\"nofollow noopener noreferrer\">https:\/\/ola.hallengren.com\/<\/a>\u00a0that, automates backup generation and reviews the backup if configured properly. However, we recommend random manual checks of the backups because it is better to be safe than sorry.<\/p>\n<p>Users of the Express version of the SQL server can create a workaround with the external tool\u00a0<span class=\"highlight\">SQLBackupandFTP<\/span>\u00a0.<\/p>\n<h2 class=\"d-flex align-items-center\" id=\"regular-updating-of-indices\">Regular updating of indices <span id='anchor-regular-updating-of-indices' data-href='#regular-updating-of-indices' class='far fa-link' data-anchor><\/span><\/h2>\t<p>Imagine the database indices like a phone book. They provide the phone numbers for each name, i.e. the entries in the database. The problem is that the data changes regularly\u2014some moves, some becomes redundant and new data is added. The SQL server generates new pages for the phone book based on the new information or moves certain entries to a different place. This results in chaos and a lot of useless information. The fragmented database causes long computing times as not all information is accessible in compressed form but is spread over several, often partially filled pages. This means that the number of accesses increases substantially.<\/p>\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<b>Attention:<\/b>\r\nDo not start the check straightaway. While the index is being restructured, it cannot be accessed. It is therefore better not to perform the check during the busiest working hours but rather sometime later in the day. Ideally, the check should be performed on a daily basis.\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n\t<p>This is how you launch the reorganisation and re-creation of the indices:<\/p>\n<ol start=\"1\" class=\"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 the menu\u00a0<span class=\"highlight\">Start &gt; Datenbank<\/span>\u00a0(Start &gt; Database).<\/li><li class=\"media-single-line\">\n\tLog in to the database and select the desired Mandant (Tenant).<\/li><li >\n\tSelect\u00a0<span class=\"highlight\">Performanceoptimierung<\/span>\u00a0(Performance optimisation).\r\n\r\nThis will take you to\u00a0<span class=\"highlight\">Mandanten optimieren<\/span> (Optimise tenants).<\/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-sql-server-007-Datenbank-Indizes.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-sql-server-007-Datenbank-Indizes.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-server-007-Datenbank-Indizes.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-server-007-Datenbank-Indizes.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-server-007-Datenbank-Indizes-768x539.png 640w\" width=\"987\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"693\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/Jtl-wawi-sql-server-007-Datenbank-Indizes.png&quot;,&quot;w&quot;:987,&quot;h&quot;:693}\" class=\"border-gray border-w-1 border 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=\"list-reset step mb-5 list-wawi normal-step\">\n\t<li class=\"media-single-line\">\n\tCheck the option\u00a0<span class=\"highlight\">Indizes neuorganisieren und neuerstellen<\/span>\u00a0(Reorganise and newly generate indices).<\/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-sql-server-008-Statistiken.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-sql-server-008-Statistiken.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-server-008-Statistiken.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-server-008-Statistiken.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-server-008-Statistiken-768x540.png 640w\" width=\"986\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"693\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/Jtl-wawi-sql-server-008-Statistiken.png&quot;,&quot;w&quot;:986,&quot;h&quot;:693}\" class=\"border-gray border-w-1 border 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=\"list-reset step mb-5 list-wawi normal-step\">\n\t<li class=\"media-single-line\">\n\tClick\u00a0<span class=\"highlight\">Starten<\/span>\u00a0(Start).<\/li><\/ol>\t<p>For users of the Standard, Enterprise or Web Editions, there is also a script provided on the Ola Hallengren site that allows you to automate this process. Users of the Express Edition need to perform a manual check.<\/p>\n<h2 class=\"d-flex align-items-center\" id=\"updating-statistics\">Updating statistics <span id='anchor-updating-statistics' data-href='#updating-statistics' class='far fa-link' data-anchor><\/span><\/h2>\t<p>Statistics are useful when it comes to generating execution plans for the SQL server. Unfortunately, the server only performs a database update when more than 20\u00a0per cent of the content of a table have changed. Large databases do not often change to such a high extent, but there are still many individual entries in a table that may have moved to a different place.<\/p>\n\t<p>Let us take a look at a more practical example: Imagine that the server is your store. The content of your database is the warehouse. The statistics are the list of what is currently in stock. A customer (i.e. the database query) arrives and wants to buy all the goods that you have received in the last 30 days. The inventory list (i.e. the statistics) has not been updated yet as the stock did not change by 20\u00a0per cent in the last 30 days. This means the salespersons has to go to the warehouse to check whether new goods have arrived. They take a basket, go to the warehouse and start searching. When they find a new item, they take it and bring it to the store. They then return to the warehouse and continue searching. They have to repeat this process for 100 new items. This takes a lot more time than if the customer knew that there were 100 new items and could have picked them all at the same time.<\/p>\n\t<p>The following paragraph explains how to update the statistics of your database. We recommend performing the update once a week. However, make sure to carry out the update in the evening or at the weekend so as not to disrupt ongoing operation.<\/p>\n<ol start=\"1\" class=\"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 the menu\u00a0<span class=\"highlight\">Start &gt; Datenbank<\/span>\u00a0(Start &gt; Database).<\/li><li class=\"media-single-line\">\n\tLog in to the database and select the desired Mandant (Tenant).<\/li><li >\n\tSelect\u00a0<span class=\"highlight\">Performanceoptimierung<\/span>\u00a0(Performance optimisation).\r\n\r\nThis will take you to\u00a0<span class=\"highlight\">Mandanten optimieren<\/span> (Optimise tenants).<\/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-sql-server-007-Datenbank-Indizes.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-sql-server-007-Datenbank-Indizes.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-server-007-Datenbank-Indizes.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-server-007-Datenbank-Indizes.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-server-007-Datenbank-Indizes-768x539.png 640w\" width=\"987\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"693\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/Jtl-wawi-sql-server-007-Datenbank-Indizes.png&quot;,&quot;w&quot;:987,&quot;h&quot;:693}\" class=\"border-gray border-w-1 border 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=\"list-reset step mb-5 list-wawi normal-step\">\n\t<li class=\"media-single-line\">\n\tCheck the option\u00a0<span class=\"highlight\">Aktualisierung der Statistiken<\/span>\u00a0(Update statistics).<\/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-sql-server-008-Statistiken-1.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-sql-server-008-Statistiken-1.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-server-008-Statistiken-1.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-server-008-Statistiken-1.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-sql-server-008-Statistiken-1-768x540.png 640w\" width=\"986\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"693\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/Jtl-wawi-sql-server-008-Statistiken-1.png&quot;,&quot;w&quot;:986,&quot;h&quot;:693}\" class=\"border-gray border-w-1 border 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=\"list-reset step mb-5 list-wawi normal-step\">\n\t<li class=\"media-single-line\">\n\tClick\u00a0<span class=\"highlight\">Starten<\/span>\u00a0(Start).<\/li><\/ol><h2 class=\"d-flex align-items-center\" id=\"less-is-more\">Less is more <span id='anchor-less-is-more' data-href='#less-is-more' class='far fa-link' data-anchor><\/span><\/h2>\t<p>Even though you now know how to optimise the software, you should not overdo it. Do not independently access the deeper functions of the database. Experience shows that this often leads to negative consequences. There are also a lot of database optimisation tools that can become a problem. Compared to the database\u2019s own tool and the auxiliary tools recommended by JTL, there are others that may prevent JTL-Wawi from accessing the SQL server. It makes more sense to take the time to install the regular security updates for the server in order to protect yourself against external threats.<\/p>\n<div class=\"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=\"d-flex align-items-center hl-wawi h3\">Video<\/p><p class=\"d-flex align-items-center hl-wawi h6\">Printer problem: No item labels are printed<\/p><div class=\"embed-responsive embed-responsive-16by9\">\n\t\t\t<div class=\"embed-responsive-item\" data-youtubeCover=\"{&quot;player&quot;:{&quot;videoID&quot;:&quot;lXDvTaM56Q0&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\/lXDvTaM56Q0-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 you will learn how to improve the performance of your SQL Server with the DB ConfigTool.<\/p>\n\t<\/div>\n<\/div><div class=\"mt-5 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\/executing-sql-on-the-database\/\" title=\"Executing SQL on the database\">\n\t\t\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t\t\t\tExecuting SQL on the database\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\/installation\/installation-of-microsoft-sql-server-express\/\" title=\"Installation of Microsoft SQL Server Express\">\n\t\t\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t\t\t\tInstallation of Microsoft SQL Server Express\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\/installation\/optimal-sql-server-setup\/\" title=\"Optimal SQL server setup\">\n\t\t\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t\t\t\tOptimal SQL server setup\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\/installation\/securing-the-sql-server-connection-of-jtl-wawi-with-ssl\/\" title=\"Securing the SQL server connection of JTL-Wawi with SSL\">\n\t\t\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t\t\t\tSecuring the SQL server connection of JTL-Wawi with SSL\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\/installation\/securing-the-sql-server-connection-of-jtl-wawi-with-ssl\/\">[&#8230;]<\/a>","protected":false},"author":2,"featured_media":0,"parent":192322,"menu_order":743,"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-192043","page","type-page","status-publish","hentry","pages_category-print-wawi-1-installation-en","pages_category-sql-en"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Tips for SQL server maintenance &#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\/installation\/tips-for-sql-server-maintenance\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tips for SQL server maintenance &#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\/installation\/tips-for-sql-server-maintenance\/\" \/>\n<meta property=\"og:site_name\" content=\"JTL-Guide\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-14T12:55:51+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=\"10 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\/installation\/tips-for-sql-server-maintenance\/\",\"url\":\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/installation\/tips-for-sql-server-maintenance\/\",\"name\":\"Tips for SQL server maintenance &#8211; JTL-Guide\",\"isPartOf\":{\"@id\":\"https:\/\/guide.jtl-software.com\/en\/#website\"},\"datePublished\":\"2018-12-19T08:36:49+00:00\",\"dateModified\":\"2023-06-14T12:55:51+00:00\",\"inLanguage\":\"en-en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/installation\/tips-for-sql-server-maintenance\/\"]}]},{\"@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":"Tips for SQL server maintenance &#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\/installation\/tips-for-sql-server-maintenance\/","og_locale":"en_US","og_type":"article","og_title":"Tips for SQL server maintenance &#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\/installation\/tips-for-sql-server-maintenance\/","og_site_name":"JTL-Guide","article_modified_time":"2023-06-14T12:55:51+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/installation\/tips-for-sql-server-maintenance\/","url":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/installation\/tips-for-sql-server-maintenance\/","name":"Tips for SQL server maintenance &#8211; JTL-Guide","isPartOf":{"@id":"https:\/\/guide.jtl-software.com\/en\/#website"},"datePublished":"2018-12-19T08:36:49+00:00","dateModified":"2023-06-14T12:55:51+00:00","inLanguage":"en-en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/installation\/tips-for-sql-server-maintenance\/"]}]},{"@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\/192043","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=192043"}],"version-history":[{"count":1,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/192043\/revisions"}],"predecessor-version":[{"id":192058,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/192043\/revisions\/192058"}],"up":[{"embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/192322"}],"wp:attachment":[{"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/media?parent=192043"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/tags?post=192043"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}