Using compression with SSMS is just as easy. Simply set the compression option on the Options page of the Back up Database dialog. You may be asking yourself: How effective is this compression? The ...

I remember a conversation I had at the Redmond campus with the program manager (at that time it was Paul Randall... now I think he goes by Paul Tripp, but all the same he's not a MS anymore.). Anyway ...