{"id":12182,"date":"2024-05-07T14:38:08","date_gmt":"2024-05-07T13:38:08","guid":{"rendered":"https:\/\/sdna.lu\/?p=12182"},"modified":"2024-05-31T15:31:04","modified_gmt":"2024-05-31T14:31:04","slug":"advanced-tutorial","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=12182","title":{"rendered":"Advanced Backup Tutorial"},"content":{"rendered":"\n<div style=\"height:44px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Follow this tutorial if you want to make a backup of a DeMaSy database(s) with specific options :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Follow the <a href=\"https:\/\/sdna.lu\/?p=12180\">Simple Backup Tutorial<\/a><strong> <\/strong>and stop before you reach the <em>Click on the backup button<\/em> stage<\/li>\n\n\n\n<li>You can now <em>set <\/em>the options you want:\n<ul class=\"wp-block-list\">\n<li>The <strong>Destination<\/strong> option allows you to choose the type of backup: \n<ul class=\"wp-block-list\">\n<li>MS Access (.mdb) is the old way and will be slower than SQL Server (.bak) type but it will not require any prior configuration in order to work<\/li>\n\n\n\n<li>On the other hand SQL Server (.bak) type is faster but you will have to provide the <em>System Administrator<\/em> (SA) credentials in <strong>INIEditor \/ Security (Network) \/ SQL Server Settings<\/strong> to make it work<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>The <strong>FileName <\/strong>option allows you to set manually the name of the backup file<\/li>\n\n\n\n<li>The <strong>Set database in read only mode (Local\/not zip file)<\/strong> option allows you to prevent those who will restore it from modifying the data<\/li>\n\n\n\n<li>The<em> <\/em><strong>Include Print \/ Temp tables<\/strong> option allows you to include in the backup different data that are generally used to generate the DeMaSy reports<\/li>\n\n\n\n<li>The <strong>Include Documents<\/strong> option have multiple values: \n<ul class=\"wp-block-list\">\n<li><em>Documents excluded<\/em> value will not include in the backup the documents related to the database(s)<\/li>\n\n\n\n<li><em>Documents fully backed up in database ZIP file<\/em> value will include all the documents related to the database(s) in the ZIP archive. So when you will restore the backup you can choose the option <em>Include Documents: Documents included in database ZIP file<\/em><\/li>\n\n\n\n<li><em>Documents incrementally backed up in separate ZIP file<\/em> value will save the related documents to the database(s) outside the ZIP archive. So when you will restore the backup you can choose the option <em>Include Documents: Documents included in a separate ZIP file<\/em><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>The <strong>Encryption Type<\/strong> option allows you to encrypt the data or not, this option have multiple values: \n<ul class=\"wp-block-list\">\n<li><em>Normal<\/em> value will not encrypt the data<\/li>\n\n\n\n<li><em>Encrypt sensitive data with 256 Unicode<\/em> value will encrypt the data with the 256 Unicode algorithm. You will need to provide a <em>key<\/em> in order that the encryption works<\/li>\n\n\n\n<li><em>Replace sensitive data with Id<\/em> value allows you to anonymize the backup, all the text data will be replaced by the SQL identifier numbers<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>In addition of the <em>Backup<\/em> button, you also have different button actions:\n<ul class=\"wp-block-list\">\n<li>The <strong>Backup Tables<\/strong> button allows you to choose the tables that will be backed up. Once you have clicked a new window will ask you the selected tables:\n<ul class=\"wp-block-list\">\n<li>The &#8220;+&#8221; button allows you to select all tables<\/li>\n\n\n\n<li>The &#8220;-&#8221; button let you unselect all the tables<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>The <strong>Backup and FTP<\/strong> button allows you to send your backup to a FTP server<\/li>\n\n\n\n<li>The <strong>Backup and Mail<\/strong> button allows you to send your backup by e-mail<\/li>\n\n\n\n<li>The <strong>Logged Users<\/strong> button allows you to see the list of users connected to the database<\/li>\n\n\n\n<li>The <strong>Missing Backups<\/strong> button will show you all the databases that need to be backed up<\/li>\n\n\n\n<li>The <strong>Full Backup<\/strong> button will make a complete backup of the DeMaSy and Licence databases with all the related INI files<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"478\" src=\"https:\/\/sdna.lu\/wp-content\/uploads\/Copy-3-1024x478.png\" alt=\"\" class=\"wp-image-12194\" style=\"width:1120px;height:auto\" srcset=\"https:\/\/sdna.lu\/wp-content\/uploads\/Copy-3-1024x478.png 1024w, https:\/\/sdna.lu\/wp-content\/uploads\/Copy-3-300x140.png 300w, https:\/\/sdna.lu\/wp-content\/uploads\/Copy-3-768x358.png 768w, https:\/\/sdna.lu\/wp-content\/uploads\/Copy-3-1080x504.png 1080w, https:\/\/sdna.lu\/wp-content\/uploads\/Copy-3-980x457.png 980w, https:\/\/sdna.lu\/wp-content\/uploads\/Copy-3-480x224.png 480w, https:\/\/sdna.lu\/wp-content\/uploads\/Copy-3.png 1224w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Special Scenario: Large Tables<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Our system is optimized to handle tables with a substantial number of records efficiently. However, when dealing with tables containing hundreds of thousands of records or more, we employ a backup method based on ranges<span class=\"hps\">:<\/span><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><span class=\"hps\">By default, the range is set to 100,000 records, but users have the flexibility to adjust this threshold by modifying the &#8216;BulkThreshold&#8217; entry in the DeMaSy INI file<\/span><\/li>\n\n\n\n<li>This approach ensures that backups can accommodate any amount of data seamlessly, without impacting the user experience<\/li>\n\n\n\n<li>However, it&#8217;s important to note that this backup method applies only to tables with a field id<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Follow this tutorial if you want to make a backup of a DeMaSy database(s) with specific options : Special Scenario: Large Tables Our system is optimized to handle tables with a substantial number of records efficiently. However, when dealing with tables containing hundreds of thousands of records or more, we employ a backup method based [&hellip;]<\/p>\n","protected":false},"author":19,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-12182","post","type-post","status-publish","format-standard","hentry","category-non-classe"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/12182","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/users\/19"}],"replies":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=12182"}],"version-history":[{"count":7,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/12182\/revisions"}],"predecessor-version":[{"id":12283,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/12182\/revisions\/12283"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12182"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=12182"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=12182"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}