The information in this applies to TANE, TRS19 and Trainz Plus. This guide will take you through the process of performing manual database repairs and clean database installs. Trainz will automatically perform database repairs when it detects corruption in the Trainz database but sometimes a manual repair or even a manual clean install of the database is required. When Trainz is operating there is a great deal of database activity going on with records being opened and closed, and data being read and written. Corruption of the data is always possible, particularly if the power supply is interrupted or the program is suddenly terminated (a "crash") while records are open or being written. For this reason, Content Manager comes equipped with automatic and manual database repair tools. A common, but not exclusive, cause of database problems and even CTDs (crashes to desktop) may be your Antivirus program. Each time Trainz access the database, your AV program may perform a real time scan of the database as well. Adding TANE.exe and/or TRS19.exe to your AV programs "real time scan" exclusion list can potentially resolve many of these CTD issues. How to Perform a Database Repair (a DBR) ---------------------------------------- From either the Trainz Launcher or Content Manager:- 1. open the Developer menu 2. select the Rebuild Database option NOTES: Perform a DBR if you have:- a. unexpected problems with missing content b. content errors with installed assets (particularly if those assets did not previously show any problems) A DBR process updates your database, revalidates the content and can often clear up any corruption that has occurred. How to Perform an Extended Database Repair (an EDBR) ---------------------------------------------------- From either the Trainz Launcher or Content Manager:- 1. open the Developer menu 2. hold down the Ctrl key 3. select the Rebuild Database option NOTES: An EDBR performs a "deep scan" of the database and checks that the data in every asset conforms to the rules for that type of asset. This is a more complex, slower and potentially more troublesome repair process as it puts every single asset in the database through the same error and compliance checks that are run when a new asset is installed. Perform a EDBR if you have serious problems with your database that a DBR does not fix. It is not unusual for CM to display a list of faulty assets after an EDBR that were not shown as faulty before the EDBR was run. How to Create a "Clean Database" -------------------------------- 1. use Windows File Explorer to create a new folder on your data drive 2. give the folder a meaningful and easy to remember name such as TRS19_Clean_Database 3. from the Trainz Launcher, click the Trainz Settings button 4. click the Install tab 5. write down the location of the Local Data Folder - you may need it again! 6. click the button [...] next to the local folder display name 7. browse to your new data folder you created above 8. select (click on but do not open) your new data folder 9. click the button [Select folder] 10. close any open File Explorer windows You will see a progress bar as the built in assets are copied across to the new folder. When the copy process has been completed:- 11. restart Trainz when you are prompted to do so 12. open the Trainz Settings again and click the Internet tab 13. delete and re-enter your username and password 14. when your username/password have been accepted, restart Trainz again 15. open the Trainz Settings again and click the General tab 16. adjust the settings to your preferred values 17. click the Performance tab and adjust the settings to your preferred values 18. exit Trainz Settings. Depending on which settings you have changed, you may be prompted to restart Trainz again 19. click on Start Trainz NOTES: Creating a Clean Database:- a. will return your Trainz database to its original, newly installed, condition b. is usually performed when the Trainz Database contains faulty installed assets that are causing crashes and other major problems c. does not destroy your original database This process will create a new Trainz database containing only the built in and base assets that came with the original Trainz installation (a "clean" database). Use this option if you want to remove from your Trainz install all:- a. DLS assets b. DLC assets - these will have to be reinstalled if you want them back c. third party assets d. assets you have created yourself (e.g. routes, sessions, etc) - but make sure that you have the original data files backed up somewhere< You will need enough space on your selected data drive to hold the data. Your original database will not be affected and will remain in its current location until you choose to delete, move or restore it. Your original database is still on your system at the location you recorded above. You may choose to:- a. leave it there (it will take up many GBs of space) b. archive or move it to offline storage c. delete it Text file created 17/Feb/2020