36.2 Restore with .bak file

36.2 Restore with .bak file

Info
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) and not just in the root of the drive (C:\restorefile.bak). If the backup is zipped, you will need to extract the .bak files first.

The following steps are done using ‘Microsoft SQL Server Management Studio Express’ found by clicking ‘Start’, ‘Programs’, and ‘Microsoft SQL Server 2008’, or whichever version of SQL Server is installed.

New Database

Add JTime DB (if not already added).

Right click Databases, select ‘New Database’.

Type in ‘JTime’ as database name (or JTime_LogYYYY where YYYY is the year) then click ‘OK’.

Restore Database

Right click on JTime database.

Select ‘Tasks’, ‘Restore’ then ‘Database’ (a new ‘Restore Database’ window is opened).

Select ‘From Device’ then click on ‘...’.

In the new window click ‘Add’, then browse for the backup file and click ‘OK’.

Ensure that the ‘Restore’ check box is selected.

Click on ‘Options’ on the top left of the window, select ‘Overwrite the existing database’.

Click ‘OK’.

This process needs to be repeated for each Log database in the backup.



    • Related Articles

    • 17.1 File Export

      File Export The file export will export the calculated totals to an ASCII file, for the Third-Party system to import. The export format is created in the File Creator, which is beyond the scope of this manual. To export the totals, first select the ...

    • 36.1 Manual Restore of Database

      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, ...

    • 14.1 Export File Creator

      Export File Creator The File Creator is used to create an export file for Third-Party System integration. If you are not completely familiar with the import batch layout of your Third-Party system, it may be advisable to arrange to have a payroll ...

    • 14.2 Details

      Details The Details tab is used to configure the line items in the output file. The items are listed from top to bottom, and will be exported from left to right into the export file. The arrow buttons on the right side move a selected item up or ...

    • 17.2 Event Type

      Event Type DEVICES NOT IMPORTING This option will produce a summary email showing which (if any) devices have been offline since last successful import. The number of hours since last import can be specified. EMAIL REMINDERS You can configure JT to ...