Interested to Buy Any Domain ? << Click Here >> for more details...
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
Sql server reporting services vs. Crystal reports.
what is create database syntax? : Sql server database administration
When does a workload on SQL Azure get throttled?
Will the writetext statement activate a trigger?
Can we write trigger for view?
what are candidate key, alternate key and composite key? : Sql server database administration
What is t-sql script to take database offline – take database online.
what is normalization? Explain different levels of normalization? : Sql server database administration
Why do we need different type of parameter?
What is dbcc command in sql server?
How to concatenate two binary strings together?
Can two different columns be merged into single column? Show practically?
What is recompile sql server?
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
How to encrypt data between dialogs?
