Answer Posted / 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 |
Post New Answer View All Answers
Is it safe to delete log files?
What are the basic features of a trigger in ms sql server?
What do you understand by physical_only option in dbcc checkdb?
What stored procedure would you use to view lock information?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
What is the recommended total size of your memory optimized tables?
what is a traditional network library for sql servers? : Sql server database administration
What does null mean?
What area unit the various kinds of info compression introduced in sql server 2008?
What is shared lock?
What is transaction server explicit transaction?
What do mean by xml datatype?
Can we insert data into view sql server?
What is efficiency data?
What will be the maximum number of index per table?