Da Notes - 70-028 - F

Personal notes on the MCDBA tests. These notes are from the various resources I used to pass the MCDBA exams including the MCDBA sample exams from Transcender.

Passing Score: 680, Questions: 52,  Time: 90 Minutes

Da Notes Index 

[ 70-028 - B ] [ 70-028 - C ] [ 70-028 - D ] [ 70-028 - F ] [ 70-028 - H ] [ 70-028 - I ] [ 70-028 - L ] [ 70-028 - M ] [ 70-028 - N ] [ 70-028 - P ] [ 70-028 - R ] [ 70-028 - S ] [ 70-028 - U ] [ 70-028 - W ]

Filegroups

Filegroups allow files to be grouped together for administrative and data allocation/placement purposes. For example, three files (data1.ndf, data2.ndf, and data3.ndf) can be created on three disk drives, respectively, and assigned to the filegroup fgroup1. 

Default filegroup: contains the PRIMARY data file

User-defined filegroup: Use the FILEGROUP keyword in an ALTER DATABASE statement. 

Samples:
ALTER DATABASE my_database, ADD FILEGROUP mydb_group

ALTER DATABASE my_database, ADD FILE
(NAME = studer2, FILENAME = 'C:\mssql7\data\mydb_data2.ndf', 
SIZE = 4) TO FILEGROUP mydb_group 

NOTE : If no 'FILEGROUP' specified this database is added to the PRIMARY group