Freshwater:
Once your pump stops pumping, water will stop spilling into the overflow and therefore, should not flood your sump, unless your sump is very small and almost full while running.
Ernie:
I have 4 returns going from my sump to the tank. The first one runs through my chiller and then runs to pipes which are buried in the sand bed and under the rocks. These pipes have small holes in them, allowing the cool water to slowly trickle up from beneath the sand. This line has 2 check valves and a safety hole. I have three other returns, one which runs to a sea swirl, and two, which run to a series of jets, hidden in the rockwork, on either side of the tank. These three are on three hour cycles, creating a sort of tide effect. The check valves are constantly going on and off since the pumps are switching on and off. This keeps them relatively clean. I also have an automatic backup generator, which kicks in 30 seconds after a power failure to give me some extra piece of mind. Even though I have been quite anal about setting things up, I still had a disaster about 1 year ago, when a temporary cannister filter hose came loose and drained my entire 600g onto my brand new $30,000 mahogoney floor and killed virtually everything in the tank. I should have posted a pic of my wife with my shotgun in her hands!