Now, backup compression is built right into SQL Server 2008, and what's even better is that it's easy to use. All you have to do is append the WITH COMPRESSION option to your backup statements and you ...

TDE will allow you to encrypt an entire database on disk without needing any changes to your applications. Backup Compression will compress your backups and speed them up too. Both are Enterprise ...

(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).

In SSMS, right-click the database and select Tasks > Back Up. Select the Files and filegroups option. Select the files and filegroups that you want to back up and press OK. How to Create a File or ...

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.).

Never back up databases to local disk. We back up SQL Servers so we can restore data in the event of a server crash. ... Sometimes, the answer is third-party backup compression software; ...

Database margin compression, helped by open source Written by Dana Blankenhorn, Inactive July 20, 2006 at 4:00 a.m. PT I had a very nice chat late yesterday with Josh Berkus , who works as the Sun ...