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 is the difference between cartesian product and cross join?
Difference between LEN() and DATALENGTH() in sql server ?
What is difference between stored procedure and user defined function?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
How do you create a data source?
How to list all dsn entries on your local machine using odbc_data_source()?
How to find table changes in sql server?
when would you go for denormalization? : Sql server database administration
Tell me in brief how sql server enhances scalability of the database system?
When cursors are useful?
Define indexes?
Can you explain what is indexed view? How to create it?
What is 1nf 2nf?
Please differentiate between a local and a global temporary table?
What is row-level compre?
