Now, just a simple BACKUP DATABASE statement will use compression. To run a backup without compression when it's the server default, simply use the WITH NO COMPRESSION option. SQL Server 2008 finally ...

(By the way, SQL Server 2008 also includes Backup Compression which is a completely separate technology – I’ll discuss that another time. Yes, both technologies can be used together).

Backup Compression will compress and speed up your backups leaving more CPU cycles for your applications and saving space too. The algorithm cut down my backup to 25% of the original size in my tests.

It turns out the SQL team at MS had never even conceived that someone wouldn’t just jump out of their skin for the chance to have backup compression in the product. My reasoning is sound.

In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

Here, Knowledge Center contributor Brent Ozar outlines seven actions database administrators can perform to build a sound database backup and recovery strategy.

For a long time Oracle could claim that there were no open source alternatives for enterprise database applications, but that is no longer the case.

IBM has entered into a definitive agreement to acquire Storwize, a privately held company based in Marlborough, Mass. Storwize provides real-time data compression technology to help clients reduce ...

No need to turn to third-party tools to keep your databases as small as possible. It's in SQL Server 2008 now.