I have multiple 1TB+ SQL databases (2k8 R2 Enterprise). I need to move a couple of them to an external vendor.
What is the best way I can move and compress them, i did a sql backup and the size of the DB is the same as it is on disk. I need to be able to compress it to an acceptable size so i can fit it on a flash drive. What is the best approach on to do this?