Differences

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

Link to this comparison view

Both sides previous revision Previous revision
sms1_-_rebuild_database [2019/02/28 14:35]
admin
sms1_-_rebuild_database [2019/02/28 14:36] (current)
admin
Line 1: Line 1:
-=Error Message=+=====Error Message=====
  
 Various database, key violation, index, or blob messages. Various database, key violation, index, or blob messages.
  
-=Explanation of Process=+=====Explanation of Process=====
  
 The Database Rebuild utility is used to repair a database table. It does this by doing the following: The Database Rebuild utility is used to repair a database table. It does this by doing the following:
Line 20: Line 20:
  
   * __All Users **must**  be out of the system for this process.__   * __All Users **must**  be out of the system for this process.__
-=Severity=+=====Severity=====
  
 High. During the rebuild process, if the old table is damaged beyond the ability to read parts, the data may be truncated or not copied into the new table. Also, if the structure is damaged, indexes are frequently lost and not found in the resulting files. High. During the rebuild process, if the old table is damaged beyond the ability to read parts, the data may be truncated or not copied into the new table. Also, if the structure is damaged, indexes are frequently lost and not found in the resulting files.
  
-=Tier 1 Actions=+=====Tier 1 Actions=====
  
   - Close all copies of SMS and the SSLIP   - Close all copies of SMS and the SSLIP
Line 44: Line 44:
       * Checking for missing data on any corrupted tables.       * Checking for missing data on any corrupted tables.
  
-=TroubleShooting DBRebuild=+=====TroubleShooting DBRebuild=====
  
   - Ensure SMS.exe or SSLIP.exe is not running in the Processes tab in the Task Manager   - Ensure SMS.exe or SSLIP.exe is not running in the Processes tab in the Task Manager
Line 50: Line 50:
   - Reboot server   - Reboot server
  
-=Task Information=+=====Task Information=====
  
   * Last Updated: 2/16/2015   * Last Updated: 2/16/2015