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
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
Give an example of why you would want to denormalize a database
What are subqueries in sql server? Explain its properties.
What are the different types of columns types constraints in the sql server?
How to return the second 5 rows in ms sql server?
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
Why SQL Agent is used?
How can we rewrite sub-queries into simple select statements or with joins?
What command must you use to include the not null constraint after a table has already been created?
How to backup SQL Server Reporting Services ?
Explain the Ways to improve the performance of a sql azure database?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
Can we use pragma autonomous_transaction in trigger?
How to create an inline table-valued function?
How many servers can we create in a single subscription?
