36.1 Manual Restore of Database

36.1 Manual Restore of Database

Info
Manual Restore of Database

In the event of data loss (e.g. stolen PC, malware, HDD failure etc), a restore from a previous backup will be necessary. This process will overwrite all information on the current database e.g. employees’ details, clockings, shift rules etc. and replace them with the contents from the backup. If you are restoring from a backup to ‘roll back’ to a previous version, it is recommended to back up the existing database first.

Note that after restoring a system a Rebuild of SQL views should be performed from ‘Setup’, ‘System Configuration’, Misc tab.



    • Related Articles

    • 36.2 Restore with .bak file

      Restore with .bak file This restore method requires .bak files to be located in a folder on a local drive. It will not restore from a network location. Sometimes it is also necessary for the file to be located in a folder (C:\backup\restorefile.bak) ...

    • 36.3 Attach a Database (.mdf & .ldf files)

      Attach a Database (.mdf & .ldf files) In some cases a backup is not available but the data from the old/crashed PC is retrievable. We can attach the actual database file as opposed to ‘restoring’ it. The location of these files is most often found in ...

    • 25.1 Manual Import of Employees

      Manual Import of Employees To import an employee which has been exported from another site, click on ‘Import’ then ‘Employees from file’ from the menu bar, then browse for the .jte files or .zip file. If you are importing from the GreenBox, GreenForm ...

    • 7.5 Revisions

      Revisions Revisions are used to Push (change to a later time) or Pull (change to an earlier time) clockings (using calculated direction), according to the rules set in this window. The results of the revisions can be seen in the ‘Calculated’ column ...

    • 11.11 Misc

      Misc The Misc tab contains an assortment of initialization options for Jarrison Time (previously found in the Jarrison.ini file), applied depending on what type of system configuration is in place and what is required. Jarrison Time and the Engine ...