Oleg Netchaev (9/3/2010)

---

Hugo Kornelis (9/3/2010)

---

- Restore and backup:

You could argue that this is simply copying pages from one place to another. What is on the page is irrelevant. The internal code to implement this is unchanged. Hence unaffected.

You could also argue that backup files of compressed databases are a lot smaller. Hence affected.

To its defense, the BOL page does state very clearly that because

Compression occurs in the storage engine and the data is presented to most of the other components of SQL Server in an uncompressed state

•Compression does not affect backup and restore.

The options in the question clearly match the How Compression Affects Other SQL Server Components paragraph of the referenced in the answer BOL page, so this is a good question.

Oleg