Power has been restored to parts of Broken Hill in far-west New South Wales after a major back-up generator failed overnight.