{"id":12711,"date":"2025-09-29T13:15:11","date_gmt":"2025-09-29T12:15:11","guid":{"rendered":"https:\/\/sdna.lu\/?p=12711"},"modified":"2025-10-15T14:14:20","modified_gmt":"2025-10-15T13:14:20","slug":"how-to-configure-sql-backup","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=12711","title":{"rendered":"How to configure SQL Backup"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">You need to specify a path to execute the backup (In the DeMaSy Utilities, on the INI Editor screen). If you don\u2019t specify a path, the default is the <strong>DeMaSy files path<\/strong> in the <strong>BACKUP<\/strong> folder.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Be careful: your path <strong>must use a UNC path<\/strong> if the folder is located on a server.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"904\" height=\"688\" src=\"https:\/\/sdna.lu\/wp-content\/uploads\/Backup1-1.jpg\" alt=\"\" class=\"wp-image-12713\" srcset=\"https:\/\/sdna.lu\/wp-content\/uploads\/Backup1-1.jpg 904w, https:\/\/sdna.lu\/wp-content\/uploads\/Backup1-1-300x228.jpg 300w, https:\/\/sdna.lu\/wp-content\/uploads\/Backup1-1-768x584.jpg 768w, https:\/\/sdna.lu\/wp-content\/uploads\/Backup1-1-480x365.jpg 480w\" sizes=\"auto, (max-width: 904px) 100vw, 904px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">For the specified folder, you must grant <strong>Full Control<\/strong> to the user <strong>&#8220;Everyone&#8221;<\/strong> if the SQL Server is located on a different server than your backup folder.<br>If your backup folder is on the same server as the SQL Server, you can grant <strong>Full Control<\/strong> to the <strong>SQL Server user<\/strong> instead of &#8220;Everyone&#8221;.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"791\" height=\"693\" src=\"https:\/\/sdna.lu\/wp-content\/uploads\/Backup2.jpg\" alt=\"\" class=\"wp-image-12714\" srcset=\"https:\/\/sdna.lu\/wp-content\/uploads\/Backup2.jpg 791w, https:\/\/sdna.lu\/wp-content\/uploads\/Backup2-300x263.jpg 300w, https:\/\/sdna.lu\/wp-content\/uploads\/Backup2-768x673.jpg 768w, https:\/\/sdna.lu\/wp-content\/uploads\/Backup2-480x421.jpg 480w\" sizes=\"auto, (max-width: 791px) 100vw, 791px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You need to specify the <strong>SQL Server user<\/strong> and <strong>password<\/strong> in the <strong>DeMaSy Utilities<\/strong>, on the <strong>INI Editor<\/strong> screen.<br>We normally use the <strong>&#8220;sa&#8221;<\/strong> user, but you can use any user with <strong>sufficient rights to create and modify databases<\/strong> in SQL Server.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"905\" height=\"723\" src=\"https:\/\/sdna.lu\/wp-content\/uploads\/Backup3.jpg\" alt=\"\" class=\"wp-image-12715\" srcset=\"https:\/\/sdna.lu\/wp-content\/uploads\/Backup3.jpg 905w, https:\/\/sdna.lu\/wp-content\/uploads\/Backup3-300x240.jpg 300w, https:\/\/sdna.lu\/wp-content\/uploads\/Backup3-768x614.jpg 768w, https:\/\/sdna.lu\/wp-content\/uploads\/Backup3-480x383.jpg 480w\" sizes=\"auto, (max-width: 905px) 100vw, 905px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">You can now perform your backup using the correct options and path.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"702\" src=\"https:\/\/sdna.lu\/wp-content\/uploads\/Backup4-1024x702.jpg\" alt=\"\" class=\"wp-image-12716\" srcset=\"https:\/\/sdna.lu\/wp-content\/uploads\/Backup4-1024x702.jpg 1024w, https:\/\/sdna.lu\/wp-content\/uploads\/Backup4-300x206.jpg 300w, https:\/\/sdna.lu\/wp-content\/uploads\/Backup4-768x526.jpg 768w, https:\/\/sdna.lu\/wp-content\/uploads\/Backup4-1080x740.jpg 1080w, https:\/\/sdna.lu\/wp-content\/uploads\/Backup4-1280x877.jpg 1280w, https:\/\/sdna.lu\/wp-content\/uploads\/Backup4-980x671.jpg 980w, https:\/\/sdna.lu\/wp-content\/uploads\/Backup4-480x329.jpg 480w, https:\/\/sdna.lu\/wp-content\/uploads\/Backup4.jpg 1448w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>You need to specify a path to execute the backup (In the DeMaSy Utilities, on the INI Editor screen). If you don\u2019t specify a path, the default is the DeMaSy files path in the BACKUP folder. Be careful: your path must use a UNC path if the folder is located on a server. For the [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1028,3,67],"tags":[],"class_list":["post-12711","post","type-post","status-publish","format-standard","hentry","category-backup","category-utils","category-technical"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/12711","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\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=12711"}],"version-history":[{"count":2,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/12711\/revisions"}],"predecessor-version":[{"id":12736,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/12711\/revisions\/12736"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12711"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=12711"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=12711"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}