Stargate Atlantis 4x20

The Last Man (1)

Sheppard returns to Atlantis after a mission and finds the city abandoned, all systems dead — and instead of ocean, sand dunes as far as the eye can see.