The photographs offer a rare insight into dressing rooms, recording studios, backstage areas and even private homes