Changes

Jump to: navigation, search

Restore IMSMA Backup on Server

1,506 bytes added, 10:34, 17 December 2017
no edit summary
{{TOC right}}{{note| If you are restoring your running IMSMA data due to in a system crashclient/server configuration, the following procedures should be performed on the IMSMA '''server'''. }} To restore IMSMA data on the server:<ol><li>Are your '''really''' sure that you will first want would like to reinstall write over the existing database on the server?</li><li>Do you have backup that contains all '''attachments'''?</li><li>Before beginning the restoration process, verify that the {{IMSMANG}} server, all IMSMA clients and its supporting applicationsall connections to the {{IMSMANG}} database from e.g. Navicat have been disconnected. For more information</li><li>If the IMSMA Control Centre icon is not already displayed in the lower, right corner of your Window’s desktop, see double-click the IMSMA 4Tray Launcher icon on your computer’s desktop.</li><li>Right-click the IMSMA Control Centre icon that is displayed in the lower, right corner of your Window’s desktop.01</li>[[Image:Backup Restore menu.02 Installation Guide for detailspng|center]]}}<li>Select '''Restore'''.</li>
{{note[[Image:Restore.png| If you are running center|400px|''IMSMA in a networked environment, the following procedures should be performed on the Restore window'']]<div align="center">''IMSMA serverRestore window''}}</div>
To restore <li>In the IMSMA data from a backupRestore window, click the [[Image:DestDir.png]] button.</li>1<li>The Open window displays. Before beginning </li><li>Navigate to the directory from which you would like to restore process, verify that the your IMSMA server and all IMSMA clients have been shut downdata. </li>2. Insert the dongle into <li>Click the computer’s USB port'''Open''' button. </li>3. If the IMSMA Control Centre icon is not already displayed in the lower, right corner <li>The path of your Window’s desktop, double-click the IMSMA Tray Launcher icon on your computer’s desktop.4. Right-click the IMSMA Control Centre icon that is displayed folder displays in the lower, right corner of your Window’s desktop.5. ''Select the IMSMA Backup and Restore option.6. Select the Start Restore option. The IMSMA Restore window displaysdirectory you want to restore from'' field. </li>
Figure 186[[Image:Restore2. png|center|400px|''IMSMA Restore window'']]<div align="center">''IMSMA Restore window''</div>
7. Click <li>In the '''Include the Following''' section, each available component in the button.The Open window displaysbackup folder is marked with [[Image:CheckedBoxIcon.8png]]. From Uncheck the Open window:a. Navigate checkbox next to the directory from which each component you would like do not want to restore your IMSMA data. </li>
{{noteNote | When selecting Components that are disabled were not included in the directory from which IMSMA backup that you would like selected to restore your . If you do not check any components, only the IMSMA data, database and any attachments will be sure restored. }}{{Warning | If the backup folder that you are about to select restore contains the folder Backup_YYYY_MM_DD_HH_MM_SS\server\attachments then all your existing '''attachments''' on the directory that server will be '''deleted''' and replaced with what is in Backup_YYYY_MM_DD_HH_MM_SS\server\attachments. This behaviour also applies when Backup_YYYY_MM_DD_HH_MM_SS\server\attachments is empty.}}<li>Click the '''Restore''' button.</li> <li>First the files outside of the database will be restored and at 20% the IMSMA Restore will ask for the password.</li>{{Note| It is named possible to change the database password with SQL software. Note that ''C:\IMSMAng\trayLauncher\TrayLauncher.properties'' also needs to be updated.}}<li>Enter the database password. [[Image:Imsma pwd2.png|center|400px]]</li><li>Click the date '''OK''' button.</li> <li>The IMSMA Restore will continue and time now the database is restored from the backup was performed.</li>[[Image:Restore3.png|center|400px]]</li><li>The attachments will be restored at 90%.</li>[[Image:Restore4.png|center|400px]]</li><li>Click the '''OK''' button. [[Image:Restore confirm.png|center|250px]]</li>}}<li>The IMSMA Control Centre closes. The IMSMA Control Centre needs to be closed because the IMSMA database restored may be of an earlier version than the current version of the IMSMA application and therefore needs to be upgraded to the same version as the IMSMA application.</li></ol>
b. Click the Open button.The name {{Warning | It is not possible to upgrade a database of the directory displays in the Select the directory you want to restore from fieldversion 1 - 5. 1508. In the Include the Following section, each item that is available to be restored is checked 04 by defaultrestoring it with version 6. Uncheck the checkbox ( ) next to each item you do not want to restore0.Items that are disabled were not backed up to the file Contact your [[Information Management Team | GICHD IM advisor]] if you selected would like to restore and cannot be included. If you do not check any items, only the IMSMA upgrade a database will be restoredof version 1 - 5. 908. Click the Restore button. A window displays one of the messages listed in Table 5404 to version 6.Table 540. Restore Pop-Up Window Messages}}
If you see this message
It means
Please enter Password
Continue to the next step.
No action taken. Database restore can only be performed on the Server.
The IMSMA database can only be restored on the server and your computer is configured as a client, not a server. Although other data can be restored on a client computer, you requested to restore the IMSMA database only or no other data was available, so no data was restored.
Restore Complete. Please note that the IMSMA database was not restored. Database restore can only be performed on the Server. The IMSMA database can only be restored on the server and If you see these messages, your computer is configured as a an IMSMA client, and it is not a server. The other data you requested possible to restore has been restored, but the IMSMA database has not been restored.{| class="wikitable"|-| [[Image:Client restore database error.png|center|400px]]| [[Image:Client restore confirm.png|center|400px]]|}
==SQL Views after restore==__NOEDITSECTION__
Since the views may build on other views it is not possible to know in which order they should be restored. Therefore the Restore functionality restores the SQL views as tables and after the restore is complete convert them to SQL views. If you still see any of your SQL views as tables after the restore, there is something wrong with your SQL views. The most common errors are:
* the SQL views are created / owned by another user than imsma
* the SQL syntax is not correct
* the SQL view is referring to another SQL view that does not exist anymore.
10. Enter the database password.11. Click the OK button. Your IMSMA data is restored from the backup. When the restore completes, a message window displays. 12. Click the OK button. The message window closes and the tray launcher closes.{{NavBox Manage Information}}
{{NavBox How To Restore}}[[Category:NAA]]
6,632
edits

Navigation menu