High availability on a subset of the data
Switch the partition to a separate table in the main database, then use bulk copy to move those rows into the secondary database.  ALTER TABLE ... SWITCH can be used to make meta-data only moves between tables, not just partitions within a table.