|
|
APPLIED EDUCATIONAL SYSTEMS, INC. |
Tech Tip # 0294 |
|
|||
|
webTRAC: Maintaining the webTRAC Database Note: Please enlist the assistance of a school technician before implementing these instructions. Three different sets of instructions apply to three different scenarios: A. I am running webTRAC 3.x or Earlier B. I am running webTRAC 4.x or Newer C. I am running webTRAC 4.x or Newer and have implemented SQL Server Standard or SQL Server Enterprise To check the webTRAC version: 1. Log into webTRAC Manager. 2. On the webTRAC virtual desktop, locate the potted plant. The potted plant is in the upper left corner of the screen. 3. Click the potted plant. 4. The build number is listed on the message board. A. I am running webTRAC 3.x or Earlier Assuming that you are not looking to backup the system state of the server, which would include the webTRAC software itself (in which case you could back up or image the entire hard disk), to backup the data only, you should focus on the following folders and files: § C:\Program Files\AES\webTRAC\data\webtrac.gdb § C:\Program Files\AES\webTRAC\data\Classes folder § C:\Program Files\AES\webTRAC\data\Students folder § C:\Program Files\AES\webTRAC\data\Teachers folder § C:\Program Files\AES\webTRAC\data\Teams folder § C:\Program Files\AES\webTRAC\data\units folder Note that C:\Program Files\AES\webTRAC is the default installation path. If your lab used a different installation path, the above locations will vary.
B. I am running webTRAC 4.x or Newer 1. Before backing up the folders and files in Step 2, execute the C:\Program Files\AES\webTRAC\bin\BackupDatabase.exe program. This takes a snapshot of the database and places it in the webtrac_backup.bak file in an effort to prevent backing up the live database. 2. Assuming that you are not looking to backup the system state of the server, which would include the webTRAC software itself (in which case you could back up or image the entire hard disk), to backup the data only, you should focus on the following folders and file: § C:\Program Files\AES\webTRAC\data\webtrac_backup.bak § C:\Program Files\AES\webTRAC\data\Classes folder § C:\Program Files\AES\webTRAC\data\Students folder § C:\Program Files\AES\webTRAC\data\Teachers folder § C:\Program Files\AES\webTRAC\data\Teams folder § C:\Program Files\AES\webTRAC\data\units folder Note that C:\Program Files\AES\webTRAC is the default installation path. If your lab used a different installation path, the above locations will vary.
C. I am running webTRAC 4.x or Newer and have implemented SQL Server Standard or SQL Server Enterprise AES recommends using a Microsoft SQL Server Maintenance Plan to maintain your webTRAC Database. Within the SQL Server Maintenance Plan, AES recommends that you plan for at least the following maintenance tasks: · Backup (Daily) · Truncate Logs (Daily) · Reindex (Monthly) · Data Integrity Checks (Monthly) For detailed instructions on how to create a Microsoft SQL Server Maintenance Plan, please see the following article from Microsoft: http://msdn2.microsoft.com/en-us/library/ms189953.aspx |
||||||
|
|
Copyright © 2007 AES, Inc. |
|
||||