Changes

Restore IMSMA Backup on Server

1,533 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> <li>In the '''Include the Following''' section, each available component in the backup folder is marked with [[Image:CheckedBoxIcon.png]]. Uncheck the checkbox next to each component you do not want to restore.</li>

7{{Note | Components that are disabled were not included in the IMSMA backup that you selected to restore. If you do not check any components, only the IMSMA database and any attachments will be restored. }}{{Warning | If the backup folder that you are about to restore contains the folder Backup_YYYY_MM_DD_HH_MM_SS\server\attachments then all your existing '''attachments''' on the 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 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 '''OK''' button.</li> <li>The IMSMA Restore will continue and now the database is restored from the backup.</li>[[Image:Restore3.png|center|400px]]</li><li>The Open window displaysattachments will be restored at 90%.</li>8[[Image:Restore4. From png|center|400px]]</li><li>Click the Open window'''OK''' button. [[Image:Restore confirm.png|center|250px]]</li>a<li>The IMSMA Control Centre closes. Navigate The IMSMA Control Centre needs to be closed because the directory from which you would like IMSMA database restored may be of an earlier version than the current version of the IMSMA application and therefore needs to be upgraded to restore your the same version as the IMSMA dataapplication. </li></ol>

{{noteWarning | When selecting the directory from which It is not possible to upgrade a database of version 1 - 5.08.04 by restoring it with version 6.0. Contact your [[Information Management Team | GICHD IM advisor]] if you would like to restore your IMSMA data, be sure upgrade a database of version 1 - 5.08.04 to select the directory that is named with the date and time the backup was performedversion 6.0.}}

b. Click the Open button.

The name of the directory displays in the Select the directory you want to restore from field.

15. In the Include the Following section, each item that is available to be restored is checked by default. Uncheck the checkbox ( ) next to each item you do not want to restore.

Items that are disabled were not backed up to the file you selected to restore and cannot be included. If you do not check any items, only the IMSMA database will be restored.

9. Click the Restore button.

A window displays one of the messages listed in Table 54.

Table 54. Restore Pop-Up Window Messages

If you see this message It meansPlease 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 these messages, your computer is configured as a an IMSMA client, and it is not a server. Although other data can be restored on a client computer, you requested possible to restore the IMSMA database only or no other data was available, so no data was restored. {| class="wikitable"|-| [[Image:Client restore database error.png|center|400px]]| [[Image:Client restore confirm.png|center|400px]]|}

Restore Complete. Please note that ==SQL Views after restore==__NOEDITSECTION__ Since the IMSMA database was views may build on other views it is not possible to know in which order they should be restored. Database restore can only be performed on Therefore the Server. The IMSMA database can only be restored on Restore functionality restores the server SQL views as tables and after the restore is complete convert them to SQL views. If you still see any of your computer is configured SQL views as a clienttables after the restore, not a serverthere is something wrong with your SQL views. The other data you requested 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 restore has been restored, but the IMSMA database has another SQL view that does not been restoredexist anymore.

{{NavBox Manage Information}}

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.[[Category:NAA]]

• ← Older edit

Alnaucler

NoPublic, bureaucrat, administrator

6,632

edits