I have used a cheap large pump with a hose on the intake and a filter sock on the outlet. Suck up the sand/ water with the pump and the filter sock attached to the outlet will catch the sand. It has been my most effective attempt to remove the sand.
what micron rating was the sock? I find the sugar sand has a lot of "dust" that gets through and into everything and anything