Call 888-890-7447

 

Shipping Solutions Help Desk

View Help Desk | Search Help Desk | Open New Help Desk Ticket

Ticket # 870
Date: 6/4/2012
Time: 4:07:43 PM

Message
Header:
Database Cleanup

Detailed
Description:
Is there a way to compress or clean up the database?
Problem Type: Databases
Version Number: Pro 7.X & Classic 6.X
Status: Closed
Solution: There is an "Optimize Database" option in the Shipping Solutions Program Group. Make sure the database is backed up and then copy it to the default directory on the C drive for either Windows 7 or Windows XP. Then go to the Start button in the lower left corner of the computer, choose All Programs, Shipping Solutions and Optimize Database. After the optimize is complete (it runs quickly), test the database by attaching to it on the C drive. Then copy it back to the location where you normally keep it.

You can also delete groups of shipments by going to the Tools menu and choosing Delete Shipments. If you delete a lot of shipments you should run the Optimize Database afterwards.