Navigation

 ·   Wiki Home
 ·   Wiki Help
 ·   Categories
 ·   Title List
 ·   Uncategorized Pages
 ·   Random Page
 ·   Recent Changes
 ·   RSS
 ·   Atom
 ·   What Links Here

Active Members:

Search:

 

Create or Find Page:

 

View Database Backup Maintenance Archiving

Category:HWeb Admin

Database Backup, Maintenance & Archiving

HWeb Database Maintenance

A.) Backup

Backup of the Hudson Databases should be done at least once a day.

1.) To backup the database, first have all users log off of all HWeb programs. Ensure that everyone has logged off by opening a single HWeb Admin select the Tools menu, then select Display Database Users. There should only be one account logged in (your HWeb Admin). If there are any other users shown, locate their machines and log off their HWeb programs. If the programs do not appear to be open, shutdown that machine.

2.) To backup the databases open an HWeb Admin program, select the Database Utilities menu, select Database Backup, now press Execute. Once the backup is complete the program will finish with a completed message, then press close.

3.) All users can now log back into the system

B.) Archiving

Archiving reservations and trips is a useful tool used to move completed reservations into a different table of the database. When reservations/trips are moved to the archive table, only those users with special permissions can access these reservations/trips.

1.) To archive reservations open the HWeb Administrator. Select the Database Utilities menu then select Archive reservation records. Enter the Archive BEFORE date, this is the date in which all reservations that have a pickup date before date selected will be archived. Now select your Archive speed. It is recommended that if archiving is being performed while users are logged into the system normal speed should be selected. It is also recommended that archiving be performed while no users are logged onto the system. If no users are logged into the system then Archive speed should be set to fastest. Finally press Execute. Run time will depend on the amount of data to be archived and the archive speed selected.

2.) To archive trips open the HWeb Administrator. Select the Database Utilities menu then select Archive trip records. Enter the Archive BEFORE date, this is the date in which all trips that have a pickup date before date selected will be archived. Now select your Archive speed. It is recommended that if archiving is being performed while users are logged into the system normal speed should be selected. It is also recommended that archiving be performed while no users are logged onto the system. If no users are logged into the system then Archive speed should be set to fastest.  Finally press Execute. Run time will depend on the amount of data to be archived and the archive speed selected.

C.) Compacting

Compacting of the database is a necessary function because of the architecture of the Microsoft Access Database. The RES2.mdb should be compacted at least once a week.  *** This setup is not done for SQL databases ***

1.) To compact the database, first have all users log off of all HWeb programs and close all HWeb Pollers (programs such as HwebBridge). Ensure that everyone has logged off by opening a single HWeb Admin select the Tools menu, then select Display Database Users. There should only be one account logged in (your HWeb Admin). If there are any other users shown, locate their machines and log off their HWeb programs. If the programs do not appear to be open, shutdown that machine.

2.) To compact the databases open an select the Database Utilities menu, select Database Compact, first select Primary then press Execute. Once the compact is complete the program will finish with a completed message. Now press Secondary then press Execute. Once the secondary compact is complete the program will finish with a completed message, now press close.

    3.) All users can now log back into the system.

Repairing (MICROSOFT ACCESS DBs ONLY “not applicable for SQL”)

In a very rare situation, the Microsoft Access Database could become damaged. If this damage should occur the database will need to be repaired. 

1.) To repair the database, first have all users log off of all HWeb programs. Ensure that everyone has logged off by leaving a single HWeb Admin open, select the Tools menu then select Display Database Users. There should only be one account logged in (your HWeb Agent). If there are other users shown, locate their machines and log off their HWeb programs. If the programs do not appear to be open, shutdown the machine.

2.) Close the final HWeb Agent. Now open Microsoft Access, open the RES2.mdb located on your network. Select the Tools menu then Database Utilities select Repair Database. The database will now be repaired.

 

Categories: