TapeTrack Documentation

Because there is more to tape management than you ever realized

User Tools

Site Tools

Trace: • setodbc • reload • volume_flag_filters • highwater_offset • upgrading • function_list • disable_update_check • data_extraction • simplemanagement • function_scanning_out
server:reload

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
server:reload [2017/06/06 21:51] – Gerard Nicolserver:reload [2025/01/21 22:07] (current) – external edit 127.0.0.1
Line 1: Line 1:
-====== Reloading the database ======+====== Reloading The Database ======
  
 You may wish to reload the TapeTrack Database for the following reasons: You may wish to reload the TapeTrack Database for the following reasons:
Line 6: Line 6:
   - You have deleted a lot of data and the database contains a lot of slack space.   - You have deleted a lot of data and the database contains a lot of slack space.
   - You have lost the database log files or the database has become inconsistent with the database log files.   - You have lost the database log files or the database has become inconsistent with the database log files.
 +  - You upgraded your Server to the latest version and the large gap between versions requires update of database architecture.
 +
 +<note tip>In heavily fragmented TapeTrack databases reloading may reduce their size by a factor of one third.</note>
 +<note warning>Large databases may take 2 to 3 hours to completely reload.</note>
 +<note warning>Although the reload procedure takes a copy of each file before reloading, please ensure that you take a full backup before attempting the reload. In the event of a reload failure you should rename the ''var/db'' and ''var/dblogs'' directory and restore from a backup.</note>
 +
 +
 +===== Automatic Reloading Of The Database  =====
 +
 +Preferred method for reloading the database as the script not only handles the reload for you, it makes the clean-up after the reload a lot easier.
 +
 +  - [[server:start_stop|Stop]] the Framework Server if it is running.
 +  - Open File Explorer and navigate to ''TapeTrack\TapeTrack Framework Server\var\db'' (default location C:\Program Files\TapeTrack\TapeTrack Framework Server\var\db)
 +  - [[server:backups|Backup the TapeTrack database files]].
 +  - Delete the folder ''$Save'' if it exists from a previous database reload. 
 +  - In File Explorer, navigate to ''TapeTrack\TapeTrack Framework Server\scripts''
 +  - Right click the file ''Reload.bat'' and select ''Run as administrator''
 +  - Click ''Yes'' to the popup to allow the script to run.  If the script closes immediately, check to make sure the Framework Server is not running.
 +  - From the command window, read through the output and click ''Y'' to continue the reload procedure.
 +  - When the script finishes the command window will close
 +  - Navigate to TapeTrack Framework Server\var\dblogs and delete the log file/s
 +  - [[server:start_stop|Start]] the Framework Server and login to TapeMaster to confirm the procedure completed correctly.
 +
 +If your login to TapeMaster was successful, open File Explorer and navigate to ''TapeTrack\TapeTrack Framework Server\var\db'' and delete the folder ''$Save''.
 +
 +
 +
 +===== Manual Reload Procedure =====
  
-===== Reload procedure ===== 
   - Notify your users that the TapeTrack System will be unavailable.   - Notify your users that the TapeTrack System will be unavailable.
   - [[server:start_stop|Stop the TapeTrack Service]].   - [[server:start_stop|Stop the TapeTrack Service]].
   - [[server:backups|Backup the TapeTrack database files]].   - [[server:backups|Backup the TapeTrack database files]].
-  - Open a command prompt as Administrator. +  - Open File Explorer and navigate to the ''TapeTrack Framework Server/var/dblogs'' directory 
-  - Change directory to the TapeTrack Database file (you can used variable [[variable:TMSS10DB|TMSS10DB]]). +  - Delete all the log files in the ''dblogs'' folder 
-  - Run the command TMSS10Server with the ''-L argument''.+  - Navigate to the ''TapeTrack Framework Server/var/db'' directory 
 +  - Delete the files ''_db.001'', ''_db.002'', ''_db.003'' and ''_db.004'' 
 +  - Open a command prompt with **Administrator privileges**. 
 +  - Change directory to the TapeTrack Database file ''TapeTrack Framework Server/var/db'' (you can use variable [[variable:TMSS10DB|TMSS10DB]]). 
 +  - Run the command TMSS10Server with the -L argument  ''TMSS10Server -L''.
   - Check the output to ensure each of the steps ended with a zero return code.   - Check the output to ensure each of the steps ended with a zero return code.
   - [[server:start_stop|Start the TapeTrack Service]].   - [[server:start_stop|Start the TapeTrack Service]].
  
 +Login to TapeMaster to make sure the database loaded correctly.
 +
 +Open File Explorer and navigate to ''TapeTrack Framework Server/var/db'', delete all (and only) files with  a file type of ''SAVE file'' or ''DUMP file'' to clean up the backup files from the database reload.
 +
 +<note warning>If the TapeTrack Database was moved to another location after the initial install the TapeTrack database may not be in the location that is reflected in the variable [[variable:TMSS10DB|TMSS10DB]].</note>
 +
 +<code>
 +C:\>cd %TMSS10DB%
 +
 +C:\Program Files\TapeTrack\TapeTrack Framework Server\var\db>TMSS10Server -L
 +Reloading Database files
 +Testing for existence of db_dump
 +Berkeley DB 5.3.28: (September  9, 2013)
 +Testing for existence of db_load
 +Berkeley DB 5.3.28: (September  9, 2013)
 +
 +             System: TapeTrack
 + Report Description: Reload Report
 +    Production Time: Tuesday, June 06, 2017 - 15:45:41 (Mountain Daylight Time)
 +       Report Width: 77 bytes
 +
 + Database File                                    db_dump  rename   db_load
 + ------------------------------------------------ -------- -------- --------
 + TMSS10.ip-connect                                0        0        0
 + TMSS10.heartbeat                                 0        0        0
 + TMSS10.dictionary                                0        0        0
 + TMSS10.dictionary-data                           0        0        0
 + TMSS10.message                                   0        0        0
 + TMSS10.message-response                          0        0        0
 + TMSS10.message-response-user                     0        0        0
 + TMSS10.journal                                   0        0        0
 + TMSS10.journal-date                              0        0        0
 + TMSS10.client                                    0        0        0
 + TMSS10.client-pool                               0        0        0
 + TMSS10.options                                   0        0        0
 + TMSS10.emailspool                                0        0        0
 + TMSS10.container                                 0        0        0
 + TMSS10.barcode                                   0        0        0
 + TMSS10.password                                  0        0        0
 + TMSS10.stock                                     0        0        0
 + TMSS10.stock-id                                  0        0        0
 + TMSS10.customer                                  0        0        0
 + TMSS10.customer-libraryhealth-totals             0        0        0
 + TMSS10.user                                      0        0        0
 + TMSS10.user-email                                0        0        0
 + TMSS10.group                                     0        0        0
 + TMSS10.zone                                      0        0        0
 + TMSS10.favorite                                  0        0        0
 + TMSS10.notes                                     0        0        0
 + TMSS10.attributes                                0        0        0
 + TMSS10.attributetype                             0        0        0
 + TMSS10.attribute-history                         0        0        0
 + TMSS10.file                                      0        0        0
 + TMSS10.file-data                                 0        0        0
 + TMSS10.file-generation                           0        0        0
 + TMSS10.dr-strategy                               0        0        0
 + TMSS10.dr-strategy-item                          0        0        0
 + TMSS10.catalog                                   0        0        0
 + TMSS10.catalog-id                                0        0        0
 + TMSS10.catalog-extent                            0        0        0
 + TMSS10.catalog-extent-time                       0        0        0
 + TMSS10.media                                     0        0        0
 + TMSS10.certificate                               0        0        0
 + TMSS10.simplemanagement                          0        0        0
 + TMSS10.consignment                               0        0        0
 + TMSS10.datacluster                               0        0        0
 + TMSS10.dataset                                   0        0        0
 + TMSS10.repository                                0        0        0
 + TMSS10.repository-move-totals                    0        0        0
 + TMSS10.media-totals                              0        0        0
 + TMSS10.volume                                    0        0        0
 + TMSS10.volume-offsitetime                        0        0        0
 + TMSS10.volume-synctime                           0        0        0
 + TMSS10.volume-container                          0        0        0
 + TMSS10.volume-dup-global                         0        0        0
 + TMSS10.volume-dup-customer                       0        0        0
 + TMSS10.volume-cmserial                           0        0        0
 + TMSS10.volume-status                             0        0        0
 + TMSS10.volume-customer                           0        0        0
 + TMSS10.volume-media                              0        0        0
 + TMSS10.volume-relaxed                            0        0        0
 + TMSS10.volume-repository                         0        0        0
 + TMSS10.volume-repository-incoming                0        0        0
 + TMSS10.volume-repository-slot                    0        0        0
 + TMSS10.volume-repository-scratch                 0        0        0
 + TMSS10.usage                                     0        0        0
 + TMSS10.usage-drive                               0        0        0
 + TMSS10.volume-container-tag                      0        0        0
 + TMSS10.history                                   0        0        0
 + TMSS10.history-archive                           0        0        0
 + ------------------------------------------------ -------- -------- --------
 +
 +C:\Program Files\TapeTrack\TapeTrack Framework Server\var\db>
 +</code>
  
-<- server:database_location|Changing the database location ^ server:advanced|Advanced Administration ^ ->+<- server:database_copy|Copying TapeTrack Database ^ server:advanced|Advanced Administration ^ ->
server/reload.1496785867.txt.gz · Last modified: 2025/01/21 22:07 (external edit)