No. The Daedalus (BC-304) survives the entire series (Seasons 2–5). It takes heavy damage in several episodes (Wraith hive attacks, Asuran satellite, super-hive) but is always repaired—often with Asgard/Ancient upgrades. It remains the flagship of Earth's fleet through the series finale and appears in Stargate Universe as the George Hammond (sister ship).