{"id":1344,"date":"2014-04-10T10:18:58","date_gmt":"2014-04-10T09:18:58","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=1344&#038;lang=en"},"modified":"2018-05-18T10:00:37","modified_gmt":"2018-05-18T09:00:37","slug":"to-do-after-backuprestore-of-demasy-and-licence-mdf-files","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=1344","title":{"rendered":"To do after backup\/restore of DeMaSy and Licence mdf files"},"content":{"rendered":"<p>After having processed a Backup\/Restore of the Licence.mdf\u00a0and DeMaSy.mdf\u00a0files, you must do the following:<\/p>\n<ul>\n<li>In the case that the Database is restored on a different Server than the\u00a0Backup, you must execute the following query on both Databases<br \/>\n(via the SQL Server Management Studio):<br \/>\n<code>SP_CHANGE_USERS_LOGIN 'Update_one', 'DeMaSy', 'DeMaSy'<\/code><\/li>\n<li>Update the Environment field in the VersionLink Table with the Environment variable from the Utilities &#8211; INI Editor<\/li>\n<\/ul>\n<p>Check the variable on the Ini Editor screen:<\/p>\n<p><a href=\"https:\/\/sdna.lu\/wp-content\/uploads\/Environment.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4148\" src=\"https:\/\/sdna.lu\/wp-content\/uploads\/Environment.jpg\" alt=\"Environment\" width=\"828\" height=\"706\" srcset=\"https:\/\/sdna.lu\/wp-content\/uploads\/Environment.jpg 828w, https:\/\/sdna.lu\/wp-content\/uploads\/Environment-300x256.jpg 300w\" sizes=\"auto, (max-width: 828px) 100vw, 828px\" \/><\/a>Excecute the following queries to update the VersionLink fields with your values :<\/p>\n<p><code>Update [VersionLink] set [VersionLink].[Environment] =\u00a0'Your Environment'<\/code><br \/>\n<code>Update [VersionLink] set [VersionLink].[PhysicalLocation] = 'Your Value'<\/code><\/p>\n<ul>\n<li>Update the following data in the Options table:\n<ul>\n<li>Report Connect<\/li>\n<li>Report Path<\/li>\n<li>Ole Path<\/li>\n<li>Document Archive Path<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>You can change the value for all the Database with a query:<\/p>\n<p>examples :<br \/>\n<code>Update [Options] set [Options].[Value] = 'YourValue' where [Options].[Variable] = 'ReportConnect'<\/code><br \/>\n<code>Update [Options] set [Options].[Value] = 'YourValue' where [Options].[Variable] = 'OlePath'<\/code><br \/>\n<code>Update [Options] set [Options].[Value] = 'YourValue' where [Options].[Variable] = 'ArchiveOlePath'<\/code><\/p>\n<p>The following is valid only for DeMaSy V6:<br \/>\n<code>Update [Options] set [Options].[Value] = 'YourValue' where [Options].[Variable] = 'ReportPath'<\/code><\/p>\n<p>Or you can change the value in the application on the options screen.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>After having processed a Backup\/Restore of the Licence.mdf\u00a0and DeMaSy.mdf\u00a0files, you must do the following: In the case that the Database is restored on a different Server than the\u00a0Backup, you must execute the following query on both Databases (via the SQL Server Management Studio): SP_CHANGE_USERS_LOGIN &#8216;Update_one&#8217;, &#8216;DeMaSy&#8217;, &#8216;DeMaSy&#8217; Update the Environment field in the VersionLink Table [&hellip;]<\/p>\n","protected":false},"author":19,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1344","post","type-post","status-publish","format-standard","hentry","category-utils"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1344","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=1344"}],"version-history":[{"count":19,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1344\/revisions"}],"predecessor-version":[{"id":6540,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1344\/revisions\/6540"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1344"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1344"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1344"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}