Over the years of use and lots of data imported from our various sales channels, our database has grown to about 80gb in size. Maintenance on a database that big can be cumbersome when rebuilding indexes, doing backups, dbcc checks, et al .
Is it possible to export / archive old data that we no longer need ?