Downgrading a database : "You can't get there from here!"

Some details around why you can't restore or attach a database to an older version of SQL Server.