Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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.

ms190635.note(en-US,SQL.90).gifNote:
Log files of read/write databases should never be placed on compressed file systems.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.