Stargate Atlantis S04 E20 The Last Man (1)

"A new gate will open. A lost city will rise again."

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.