How to restore an H2OS backup, alternate procedure

 

This procedure replaces files in your H2OS installation from those in the backup.

 

The backup contains all data tables that H2OS uses. The backup does NOT include executables (which are fixed with each installation, including the one being restored to, which may be at a higher maintenance level then the backup, but that should be okay. If not, may have to clear the maintenance log and run tabmods again to cover changes made in the time period between the taking of the backup and the date it's restored).  

 

To restore a full H2OS backup

 

1. Quiese H2OS (nobody can be running H2OS on any workstation or server at this time, until the restore completes and is checked out)

 

2. Rename your H2OS folder from C:\H2OS folder to C:\H2OS_old

 

3. Create a new (empty) folder named C:\H2OS

 

4. Locate and have the backup file ready.

 

The backup to be restored can be located anywhere that this computer can access. Performance will improve if you place a copy of the backup to be restored from a folder on this computer. The H2OS BACKUPS folder (see Setup->Options->Backups, set by default to c:\backups) is a good place.

 

For the purposes of this procedure, we'll assume the backup you want to restore is located at c:\backups\h2os_backup_ccc_08_10_2011_18_47.zip.    (replace ccc with your H2OS customer ID)

 

Translated, the backup name means it was created for h2oscustomerid on 8-10-11 at (approximately) 18:47 (6:47pm)

 

 

 

5. Locate and run c:\h2os\h2os_recover.exe

 

First, create a shortcut if one doesn't exist

 

If you do not have a desktop shortcut for this program, please create one now. Take just a moment. This is a necessary pore-requisite to using the restore program because it must not only be started, but started from a certain folder (your renamed H2OS folder) because a control file used by the restore program must be accessible to the restore program when it starts via the startup path, which is set in the shortcut but cannot be specified by simply double-clicking the restore program name in Windows Explorer to start it that way. If started incorrectly, the restore will not operate correctly.  

To create a Windows shortcut, right click your mouse in an open area of your desktop screen and select NEW -> SHORTCUT.

 

Set the target to

 
C:\h2os_old\restore_h2os_full_backup.exe -cC:\h2os_old\config_restore.fpw

and set the "starts in this folder" to:

c:\h2os_old

 

 

Run the restore program

Note: If your copy of this program (restore_h2os_full_backup.exe) is corrupted or missing,  you can download it here (after downloading, unzip the file it contains into your c:\h2os_old folder).

 

 

6. Launch the utility by clicking the desktop shortcut

 

 

Confirm and click YES

 

 

 

 

Click OK

 

 

Click YES

 

 

Click YES


 

   The utility will ask you to locate the backup file to be restored

 


 

 point to the new, empty folder to receive the restored database (the new C:\H2OS folder)
 

 

Proceed to run the restore, and wait for it complete
 

If it does not complete normally, follow the messages on the screen (and take and store screenshots for follow-up analysis)
 

 

8. If it completes normally, start H2OS using  your old desktop shortcut (which still points to c:\h2os from the initial installation).
 

9. Check your database and confirm the corruption is gone. If not, you will need to restore to an earlier backup. Repeat this process (going back in time) until the corruption is gone.
 

10. Run a maintenance check and let the software update itself (and perform any database changes introduced by maintenance since it was last applied to the now-current installation).
 

11. Re-apply any database and/or file changes that you (and not H2OS software) have made to the database since the backup was taken

 

 

notes:

 

  1. The location of the H2OS backups folder is saved in setup->options->backups.  

    Caution:
    never place the backups folder in the C:\H2OS (product installation) folder structure (that is, do NOT create and use a folder in c:\h2os such as  c:\h2os\backups), as that would cause backups to be created in the same folder collection that is being  backed up. This will cause the next backup to contain the last backup, and so on, until the size of the backup is out of control. Always keeping your backups away from c:\h2os, perhaps on a different drive or computer on your network.
     

  2. the restore process cannot be used to transfer your H2OS installation to another computer, as the original H2OS installation installed some Windows files that must exist on the computer that is running H2OS. In any case, H2OS itself is licensed for a computer or LAN server and it's workstations, but not multiple computer installations, so to install H2OS on a separate computer, please download and install a full copy of the product (which will be in 30 day demo mode until the activation key is entered).  

    An exception to this is moving your H2OS installation to another computer
     

  3. For LAN server installations, this operation is performed on the server. For LAN workstations, which share the H2OS database on the server, you can either reinstall the product on the failed workstation or restore a backup taken of the workstation, if doing so is part of your backup strategy.  

 

 

Also see:

 

 

About automatic backups

backup controls

how to backup the database

how to setup automatic daily backups ...

How do I move H2OS to another computer

How to restore customers and job tickets from audit trails