*** If your company has a current support plan, you can contact firstname.lastname@example.org to schedule an appointment with us and we can perform a data archive for you. If you do not have/want support or if you prefer to do this yourself, you can do so by following the steps in this article. ***
1. Archiving can only be performed on your server. For extra security, make a copy/backup of your live data folder before proceeding.
2. Stop the Nexus server via services.msc
3. Create a folder in the same directory where the live database resides. You can name the folder anything you would like but use underscores in place of spaces.
i.e, use Archive_2015 as opposed to Archive 2015
4. Open up the live data folder and copy all files except for any config files such as nxTrans.cfg, etc
5. Paste the copied files in the new archive folder
6. Restart Nexus server in services.msc
7. Right click the new archive folder you created and select Properties-->Securities then Edit-->Add a new user called 'drd' and give them full access
8. Open up localhost:10088 (Chrome works best, there are issues with IE and this site at times.)
If you cannot open the localhost site via the internet, download the Admin Tool and select Server Management.
Download Admin Tool
9. Click on TCP/IPv4 Transport on left side of menu and deselect 'Active' then save changes.
10. Click on Aliases on left side of menu and add a new alias then save changes. Alias name will be the name of the archive folder you created (Archive_2015, etc) and the path is going to be identical to the location of the folder in Windows Explorer. An example path is: C:\ProgramData\Holland Solutions\DrDispatch 5\Archive_2015. Click Save Changes when done.
11. Go back to TCP/IPv4 Transport and reselect 'Active' then save changes
12. Open up Dr Dispatch and select System-->Open Database-->Archive. Verify everything opens up correctly, all of the data/loads are there, etc.
13. Close Dr Dispatch and open up the Nexus Enterprise Manager (download via attachment->>see BOTTOM LEFT of this page)
14. Select server IP address on left side then browse to drd5-->Tables -->bload (for brokerage) or tload (for trucking.) In our examples, we will refer to the bload table.
16. Clear SQL screen and enter:
delete from bload where drop_date <=date '2013-01-01'
(You can use whatever date you want.)
Press Ctrl + E on your keyboard to execute. In a few seconds, the query results will display at the bottom of the screen.
If you want to archive based on pro numbers, the SQL would be:
delete from bload where pro_no<=79999
(Use whichever pro # you need.)
17. Close Enterprise Manager and open up Dr Dispatch-->drd5. If you want to verify that the SQL statement worked, go to Load View-->All Loads and wait for total count to populate at the bottom of the screen. Do the same in the archived database and compare the numbers - they should be significantly different.
18. If you get any errors opening up the archived database, exit Dr Dispatch (kill it in Task Man if necessary) and run the Update Manager. The default location is:
C:\Program Files (x86)\DrDispatch 5