what are file groups?

Question Posted / dinesh gupta

3 Answers
10003 Views
Evalueserve, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what are file groups?..

Answer / j.jyothy

Filegroup is a logical container for the collection of
datafiles.(.mdf or .ndf that is primary file group or
secondary file group)
Every database contain 2 file groups
1.Primary file group, which Contains all the primary data
files any other Secondary datafile which is not
specifically allocated to anyother file groups
2.User defined file group:It is created by the user to
group the datafiles

3.transaction log file:Does not belong to any file group.A
database can have maximaum of 32,767 file groups

Example:
Create database student
on Primary ***Primary
(
name='student_pri_data1.mdf',
filename='g:\student_primary_data1.mdf',(Location of this
file group)
size=2mb
maxsize=10mb
filegrowth=1mb
),
filegroup student_group1 ***Secondary
(
name='student_Sec_data1.mdf',
filename='g:\student_sec_data1.mdf',(Location of this file
group)
size=10mb
maxsize=12mb
filegrowth=2mb
)
log on ***log file
(
name='student_log_data1.mdf',
filename='g:\student_sec_data1.mdf',(Location of this file
group)
size=12mb
maxsize=10mb
filegrowth=1mb
)

Is This Answer Correct ?

7 Yes

1 No

what are file groups?..

Answer / priyanka

Filegroups are named collections of files and are used to
help with data placement and administrative tasks such as
backup and restore operations.

Is This Answer Correct ?

6 Yes

1 No

what are file groups?..

Answer / anuj

Filegroups are group or collection of Files that is used to
maintauined the transaction of Data and Restore Operations.

Is This Answer Correct ?

3 Yes

4 No

Post New Answer