This topic has not yet been rated - Rate this topic

Designing Files and Filegroups

SQL Server 2008 R2

You can add data files and filegroups to a database to improve database performance and enhance your backup and restore strategies.

Topic	Description
Using Files and Filegroups	Provides recommendations and guidelines for designing multiple files and filegroups.
Using Files and Filegroups to Manage Database Growth	Provides recommendations for file and filegroups size.
Read-Only Filegroups and Compression	Describes read-only filegroups and how to put read-only filegroups on disks using NTFS compression.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions