The sale of a business is often viewed as a defining moment of success, both for the entrepreneur and their family, despite the challenges faced along the way.