Any one here use SQL Anywhere 5. I want to resize a database that has grown up to 2Gb in size. I have implemented a database purge that will purge out information older than a year. Even though the database has been purged the database size remains at 2GB. Is there a way that I can shrink the database down to a normal 450-600MB file? I could not find any information on the web about a resizing or compacting. Options that were given to me were to replace the old large database with a new smaller database. This would allow a database that would not grow to that size again. Any one have any suggestions? This Database is running on a WIN2K server.
