This article will explain how to create and use the File and File Group in SQL Server 2008.
What are Database Files and File groups?
For this question you can see the link: http://technet.microsoft.com/en-us/library/ms189563.aspx
How to create Files and File Groups?
Please see the below steps to understand how to create files and files groups.
STEP 1: Create a File Group Folder.
Create a folder where you need to store this new file group. Create a “DemoFileGroup” folder in D: drive. i.e D:\DemoFileGroup
STEP 2: Create a Database.
Now create a “Demo” database by using Right Click -> New Database. It will open the New Database window. Please see the image for further details.
Now click on “Add” button to add “New” the File and File Groups to this Database. It will add a new row at bottom. See the below images.
After that Click on File group drop down list. It will give you all the available file groups.
Now select the <new filegroup>.
It will open the New Filegroup for Demo window. Enter the “DemoFileGroup” name. Then click on “Ok” button.
Then choose the file path as “D:\DemoFileGroup” which is created in STEP 1.
Give the File Name as “DemoFile.ndf”. See the below Image.
After this you File group will be automatically created. See the below images.
Finally click on “OK” button. The database is created successfully with you new file group.
Assign File group to table.
Create an “Emp” table as shown in the below:-
After creating the table, edit the table and go to his properties window. See the below figure.
Change the filegroup or partition to “DemoFileGroup”
and save the table. That’s all.
Conclusion
Hope you will enjoy this article. Please provide the suggestions on this article in comments section.