Battle of the Super-hive

The Battle of the ZPM powered Hive Ship was a battle between the Wraith, Kenny's, ZPM powered Hive Ship and the Tau'ri. The battle took place in the Pegasus and Milky Way galaxies, and over Earth in 2009.

Prelude
At the Battle of Asuras, Todd was able to steal a number of Asuran Zero Point Modules before the planet was destroyed. He used some of them to power his massive cloning facility, and set his underling, Kenny, to work on devising a way to integrate the ZPMs into a Hive ship.

The retrofit took well over a year to complete due to the incompatibility between Ancient technology and the organic nature of a Hive Ship. However, when Kenny was finally able to make it work, he mutinied, chasing Todd from the Hive. Todd crash landed on an unknown planet with a Stargate and dialed Atlantis. He apprised the Expedition of the situation and was permitted back into the city, to yet again ally against the Wraith, though with his track record of duplicity, the Expedition remained suspicious, notably John Sheppard. He revealed that the ZPM powered hive ship was still in the process of upgrading its systems, and if the process is allowed to complete, the Hive would be unstoppable.

The Battle
Todd urged Woolsey to attack and destroy the Hive Ship before it became a threat to Atlantis. Onboard the Daedalus, Colonel Caldwell, Colonel Sheppard and the rest of the team rushed to engage the new Hive ship. However, the ZPM powered vessel proved itself an impressive opponent, crippling the Daedalus before it made a sudden jump into hyperspace to Earth, following coordinates from a weak subspace signal in Wraith code sent, through subspace, from another reality. They then notified Stargate Command via Atlantis once the communications array was repaired.

In the Milky Way galaxy, Colonel Ellis and two of Earth's BC-304 starships, the Apollo and the new Sun Tzu, failed miserably to stop the Wraith ship, with the Apollo, in bad shape herself, taking on crew from the crippled Sun Tzu. Then then relayed a message back to Atlantis, detailing the failure to stop the Hive.

Meanwhile, Sheppard interrogated Todd for the location of more ZPMs, which Lorne and his team were able to locate; Atlantis, with her full complement of three ZPMs, will return to Earth in a last-ditch effort to defend it. Carson Beckett flew the city until the hyperdrive failed. Zelenka proposed activating a highly experimental and potentially dangerous drive based on the same wormhole technology as the Stargate. With it, they reached Earth in seconds.

When Atlantis arrived, it placed itself in a position between the Hive and Earth in order to buy the SGC some more time. Atlantis took the brunt of the hive ship's assault on Earth and launched a barrage of drones in retaliation. The sheer force of the Hive's weapons fire pushed the city ship into Earth's atmosphere, and it strained the shield. With little power left, Beckett could either have adjusted the course of Atlantis, or kept firing at the enemy ship; Woolsey gave the order to keep firing. The SGC eventually succeded in destoying the Hive, but Atlantis was forced to make a landing through Earth's atmosphere.

Aftermath
Everyone at Stargate Command erupted into celebration when Atlantis landed successfully over water. The city was able to cloak just before their approach, and the area in which they landed is under naval quarantine, so for now at least, Earth's population is still in the dark.

John visited Todd, who still is locked in a holding room. Todd boasted about his help in saving Earth because of his ZPMs and asked if John has come to kill him, who does not respond. Ronon was visited in his infirmary bed by Amelia Banks, who took him to join the rest of the senior Atlantis staff on a balcony overlooking the Golden Gate Bridge.