Database Repair - BiblioTECH Library Management System

Go to content

Main menu:

Database Repair


If the BiblioTECH Server is unexpectedly shut-down (usually resulting from a power failure) it is possible that the BiblioTECH database may become corrupt. After this, there can be a number of symptoms that could arise, such as:

  • Server services not starting
  • Clients not connecting
  • Clients not able to perform specific tasks


The database can be repaired using our BT8repair utility.

  1. On the BiblioTECH Server download the utility.
    1. Note: As some sites cannot download an .exe file, the utility has been compressed into a .zip file.
  2. Once downloaded, extract the utility from the downloaded .zip file to a convenient location.
  3. Stop all BiblioTECH services.
  4. Copy the files in C:\ProgramData\BiblioTECH\v8\Server\Data to another location (do NOT copy any sub-folders).
  5. Run the BT8repair utility. This will:
    1. Create a 'time-stamped' sub-folder   PreRepair_yyyymmddhhnn
    2. Process each database table file.
    3. Copy the table file into the above folder with the prefix original_
    4. Create a new empty table.
    5. Process all of the records in the original table, with 'good' records transferred and 'dud' records logged.
    6. When done it will display the counts of original, 'good' and 'dud' records.
  6. Start Task Manager and monitor CPU usage under Performance.
  7. Start the BiblioTECH Database (BT8_DBservice) and Communications (BT8_SVRservice) services. When the CPU usage drops to a consistent value less than 10%, you can start a Client to verify all is working properly.

+61 3 9502 3056
9am - 12pm Victorian Public School Days
913/43 Therry Street
Melbourne 3000
Victoria, Australia
+61 3 9502 3056
9am - 12pm Victorian Public School Days
Sales

Administration & Licencing

Technical Support
BiblioTECH International Pty. Ltd.
17 Keith Street
Hampton East
Victoria 3188
Australia
+61 3 9502 3056
9am - 12pm Victorian Public School Days
913/43 Therry Street
Melbourne
Victoria 3000
Australia
+61 3 9502 3056
9am - 12pm Victorian Public School Days

913/43 Therry St, Melbourne
Victoria, Australia 3000
Copyright © 1995-2018
BiblioTECH International Pty. Ltd. ABN 79 087 036 235
Copyright © 1995-2018
BiblioTECH International Pty. Ltd. ABN 79 087 036 235
Back to content | Back to main menu