Readme_FileGroups

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:

• The WorkOrderGroup filegroup and the data file WorkOrders and then moves the Production.WorkOrder and Production.WorkOrderRouting tables to that filegroup in the AdventureWorks sample database.
  
• The TransactionHistoryGroup filegroup and data file TransactionHistory and then moves the TransactionHistory and TransactionHistoryArchive tables to that filegroup in the AdventureWorks sample database.
  

Transact-SQL

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

• SQL Server 2005, including the following components:
  
  • Database Engine
    
  • SQL Server Management Studio
    
  • AdventureWorks (OLTP) sample database
    
  • SQL Server Engine samples
    

The following procedure shows how to run the CreateFileGroups.sql Transact-SQL script that creates files and filegroups in the AdventureWorks sample database.