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
What are the different types of cursor?
What happens to a statement batch if there is a compilation error?
What are the functions in sql server?
What do you understand by intent locks?
can you implement data mining in SSRS?
What is the use of partition by in sql server?
How much memory that we are using in Logshipping Concept?
what are triggers? : Sql server database administration
What does COMMIT command do?
Why truncate is ddl command?
What is a cube? : sql server analysis services, ssas
Why use “nolock” in sql server?
What is difference between count (*) and count 1?
How to return the date part only from a sql server datetime datatype?
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
