Designing Files and Filegroups

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

In This Section

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.

See Also

Concepts

Understanding Files and Filegroups

Other Resources

Designing Databases

Help and Information

Getting SQL Server 2005 Assistance