How To Restore A PayClock Database Archived File
|In PayClock, Archiving historical data removes older pay periods from the database. Restoring or importing that data will add the data back to the database. If the archived files are lost or damaged, the data cannot be restored. Archive Files are only viewable when they are restored in the software.
IT IS ALSO RECOMMENDED TO BACKUP THE CURRENT DATABASE BEFORE IMPORTING AN ARCHIVE. If the incorrect file type is imported, the current database it will overwritten. This cannot be undone!
To restore an archived file to the PayClock Database:
The data from the Archive file should display as a Closed Period in the PayClock Report Manager or as Historical Data on the timecard. If the dates appear out of order, the indexes must be repaired.
- Close PayClock.
- Open Database Manager.
A Database Manager icon may be on the desktop. If it is not on the desktop, click Start | All Programs | PayClock | Database Manager.
- In Database Manager, click the Backups icon on the Ribbon Bar at the top of the screen.
- Click the Import A Database icon .
In older versions of PayClock, click File | Import A Database from the menu bar.
- In the Database Restore Manager, click Browse.
- Locate the archive file.
- On Import Database From, change the File Type at the bottom to TDA.
- Browse to the location where Archive Files are stored.
By default, PayClock uses the PayClock\Database\Backup folder for storing backup and archive files. If a different location was used, navigate to that location.
- Select the Archive File that contains the Historical Pay Periods needed and click Open.
- After the Archive (TDA) file has been selected, click Import on the Database Restore Manager.
- In the Validate Restore window, type Yes where indicated.
- and click OK.
Since this is an Archive File, the Data will be added onto the current database. The current database will NOT be overwritten.
- When the import process is complete, close Database Manager.