SGU Stargate Universe Season 2 Episode 6

After returning from Earth (via the communication stones), Col. Young is somewhat depressed as his wife asked him for a divorce. He's drinking heavily and begins to have a recurring dream where the Destiny is attacked by the aliens they had earlier encountered. They are demanding Chloe's return and in the first few dreams, his refusal to do so leads to the Destiny's destruction.