Backing Up and Restoring Files and Filegroups
Apress eBooks · 2008
The concept of a filegroup has been in place since the introduction of SQL Server 7.0. Essentially, a filegroup is a construct to provide a logical storage location for an object when it is created. Thus, you can put different tables and indexes in separate filegroups to not only improve performance, but more important, to minimize backup and recovery times. As a database grows and performance and maintenance demands increase, the usage of filegroups becomes a necessity. New features within SQL Server 2005 leverage filegroups; some focus on performance, and some improve filegroup involvement in disaster recovery. These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.