How to remove @ptitude Analyst history data using MS SQL scripts

Summary

This procedure will guide you how to set the number of months you wish to keep data in @ptitude Analyst.
Note: You must have a BACKUP of the database before you run this, as it will delete data.

Solution

1. Log in to the MS SQL Server as skfuser1
   
   
   
   

2. There is a Stored Procedure in the skfuser database under Programmability > Stored Procedures
   
   
   
   

3. Under Stored Procedures, right click on the skfuser1.dbtools_RemoveOldHistory and select Execute Stored Procedure...
   
   
   
   
4. In the newly opened pop-up window, type the number of months you wish to keep the data
   
• If you enter 60, the measurements will be saved for 5 years
• If you enter 72, the measurements will be saved for 6 years
• If you enter 84, the measurements will be saved for 7 years
5. The procedure can take longer to complete. Ensure that during this period, no one is logged in to @ptitude Analyst and no backups are performed.
   
   
   
   

6. When the procedure is finished, under Results, you should see Records successfully removed
   
   
   
   

7. The procedure has now created free space in the Database files. You must shrink the Database and files to reclaim the space. Right-click on skfuser > Tasks > Shrink > Database
   
   
   
   
8. You can now see the Available free space
   
   
   
   
9. Click OK. The window will be closed when the shrinking action is completed.

Contacting SKF Technical Support Group

For further assistance please open a support case using the Technical Support group's self-help portal at www.skf.com/cm/tsg. Once your support case is submitted, a technician will contact you to begin working on your issue. For urgent issues we are available at these times by phone:

• Monday through Friday, 5:00 a.m. to 4 p.m. Pacific Time -
  Phone: [phone] within the US or [phone] outside the US.
• Monday through Friday, 8:00 a.m. to 4:00 p.m. Central European Time -
  Phone: [phone].
• Monday through Friday, 7:30 a.m. to 4:30 p.m. India Standard Time -
  Phone: [phone].