So I installed SQL Server 2008 on my work laptop, since I wanted to do some testing of it.
One thing that has always annoyed me at work is having to manually log into the server in order to compress the backup file. So one of the first tests I did with the new installation was to backup the Reporting Services database both without and without the new backup compression feature. I must say that I like the results so far.
| Without Compression | With Compression |
| 2,91 MB | 672 KB |
Not only will this save me time during development, it will also cut down on the traffic costs to our hosting center.