Readme_FileGroups



The purpose of this sample is to demonstrate filegroup and file capabilities in Microsoft SQL Server 2005. For information about this feature, refer to the topic, "Designing Files and Filegroups" in SQL Server Books Online.

Scenario

Filegroups allow files to be grouped together for administrative and data allocation/placement purposes. For example, filegroups allow placement of objects on specific physical disks, which can improve performance due to parallel disk I/O searching. Also, files and filegroups can be backed up and restored individually, which can increase the speed of recovery by allowing you to restore only damaged files without restoring the rest of the database.
This sample creates:

Languages

Transact-SQL

Prerequisites

Before running the sample, make sure the following software is installed:

*
SQL Server 2005, including the following components:

Running the Sample

The following procedure shows how to run the CreateFileGroups.sql Transact-SQL script that creates files and filegroups in the AdventureWorks sample database.
Running the CreateFilegroups Sample
  1. From SQL Server Management Studio, open the file CreateFileGroups.sql script located in the C:\Program Files\Microsoft SQL Server\90\Samples\Engine\Administration\FileGroups\Scripts folder, and click Execute. © 2007 Microsoft Corporation. All rights reserved.