Filegroups

Filegroups allow database files and objects to be logically grouped together. Tables, indexes, text datatypes, ntext datatypes, and image datatypes can be placed on specific filegroups (see Figure 8.15). By spreading database I/O across hard drives, filegroups provide the potential to improve database performance. Filegroups can also simplify administrative tasks such as backing up a filegroup or adding new files to new disks.

Figure 8.15. Filegroups.

NOTE

If you are considering implementing filegroups, you should consider implementing hardware with RAID technology. A high quality RAID system can often deliver performance gains similar ...

Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.