One of the new capabilties of SQL Server 2008 is backup compression. This is a feature that has been much needed. The difference between SQL Server 2000 and SQL Server 2005 was like night and day. Now with SQL Server 2008, we are seeing some nice refinements. Backup Compression is a great example of this. Before this release if you wanted the benefits of backup compression you had to use a third party tool. I like that you now get this in the newest release. 

This new feature is incredibly easy to use....

BACKUP DATABASE Sales

TO SalesBackup

WITH COMPRESSION

Yes its that easy to use. At Ntirety we are in the business of Remote Database Administration.  When we bring in new triage people, we start off by teaching them SQL Server basics. They think to themselves, this is easy. When we start teaching them how to do the similar commands in Oracle, that when we get the deer in the headlight look.

How much compression you will see depends on the structure of your particular database. One of things I really liked was how easy it was in SQL Server 2008 was how easy it was to make compression the default behavior for all backups.

If you want to learn more about SQL Server 2008, check out the Ntirety Video Gallery.  We have lots of Videos we did in cooperation with Microsoft that talk about SQL Server 2008. Here is a link to the Video Gallery...

Posted by Michael Corey

www.ntirety.com