Ok I found a great link on YouTube that shows exactly what I need to do.
Chas. Water and electricity yeah your right, luckily the two don't touch as this is an air pump that sits in a nice dry box and just pumps air down a tube if or when the main power fails. I've had one spikey hair do, never again.
Kinmel. Apparently there is a 'piggy back' plug that plugs into the mains and the 'water pump' plugs into it. The piggy back has a wire that goes to the relay (held open by the 240v) and in the event of a power out the water pump stops and the lack of 240v closes the relay Which completes a circuit between the 12v battery and the air pump.
I wasn't sure what type of relay it was and that's why I asked you guys. Lots of knowledgeable guys here who know the wizzardry ways of electrickery. Anyway due to a new video posted the relay is now visible for all to see along with an explanation. Thanks anyway! U2
Bob, good thinking I'll check those systems to see if they have the same relay.