• Even though you can't use full partitioning, I would think that partitioned views could help ... especially if the older data can be effectively held in "archive" tables on different filegroups. Then you may not need to run full backups, just filegroup backups. If you can mark some filegroups as read-only, you won't have to back them up at all on a regular basis.

    Matt.