what are file groups?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
What are the different Topologies in which Replication can be configured?
mention different types of relationships in the dbms?
What is partitioned view?
How to configure and test odbc dsn settings?
What is a transaction and what are ACID properties?
14 Answers Config Systems, IBM, TCS, Virtusa,
What are recommended options to be used while using db mirroring? : sql server database administration
Can we perform backup restore operation on tempdb? : sql server database administration
What will happen if a column containing char type data is changed to the nchar data type?
what is the output for this query select * from employee where 1=1;
I have a huge amount of data which is displayed in a report. The data is viewed every day. Every day the data is displayed in 30 secs but suddenly today it is giving an timeout message today. Data has not been changed. The situation is same as yesterday. What might be the reason??? Please Answer.
What is INTVAL( )and where we use Plz any body help me
What is ssl in sql server?