restructure tss data 3.23 mtas like defrag for tss data run nightly or at least end of day once a week

restructure tss data 3.23 mtas like defrag for tss data run nightly or at least end of day once a week


This process should only be run when nobody is in TSS.

 

From the server computer down to the left of the time look for an icon first that looks like an upside-down V or the tip of an arrow.

Under the ^ look for the green IN icon then double click that icon it will open a window like

 


from there go to tools data management and do the third choice which is Restructure TSS Data 

It will ask you two questions are you sure you want to run the restructure you click yes.

Then it will ask if you want to stop the application server and you click yes to that and then it will go through and complete the process of running like the equivalent of a defragment for the TSS data. 

 

    • Related Articles

    • How do I run the end of day procedure in TSS XP?

      To run the end of day procedure in TSS go to the reports section, click on functions, then click on Run End of Day. The default end of day reports are as follows. Salesperson Profitability Report: This report subtotals by salesperson, showing the ...

    • Starting TSS XP Problems

      TSS XP has two components to it MTAS.exe and TSSXP.exe The MTAS.exe without it running and able to communicate through the firewall, TSSXP will not run The mtas program does lots of things two important things it does it controls updates from the ...

    • How can I add a report to the End of Day or End of Month procedure in TSS XP?

      Find the report you wish to add, highlight the desired report and change the criteria bottom of the screen. Run the report and then click report groups, then click add current report to end of day.

    • Backups in both TSS Plus and TSS XP

      TSS PLUS: Backups are easily created through the Database Maintenance Wizard when you click on the Ambulance icon in the bottom right of the TSS main menu. Select 'Manually Specify', click next and choose 'Backup Database Files', select the ...

    • How do I re-run the last update in TSS XP?

      Close all workstations out of TSS. Go to the computer with a local installation of TSS, then right click on the TSS shortcut, and go to properties. Verify the path is to a local drive (you cant apply the update over the network), and click on open ...