File Backup and Restore and Compression
Microsoft SQL Server 2005 supports NTFS file system data compression of read-only filegroups and read-only databases. For more information, see Read-Only Filegroups and Compression.
Restoring files in a read-only filegroup is supported on compressed NTFS files. Backup and restore of these filegroups works essentially as it would for any read-only filegroup, with the following exceptions:
- Restoring a read-write file (including the primary or log files of a read-write database) to a compressed volume fails and displays an error.
- Restoring a read-only database to a compressed volume is allowed.
For more information about how to back up read-only filegroups or databases, see Differential File Backups and Backing Up Read-Only Databases.
Note
Log files of read/write databases should never be placed on compressed file systems.
See Also
Concepts
Read-Only Filegroups and Compression
Securing Data and Log Files