E-Books for you

When creating a database initially, you specify filegroups and specific files as subclauses
to the CREATE DATABASE statement:
CREATE DATABASE AWSample
ON
PRIMARY(
NAME=AWSampleData,
FILENAME='D:\data\AWSData.MDF,
SIZE=2000,
FILEGROWTH=200),
FILEGROUP AWSampleData (
NAME=AWSampleData1,
FILENAME='D:\Data\AWSD1.NDF',
SIZE=2000
FILEGROWTH=200),
FILEGROUP AWSampleIndex(
NAME=AWSampleIndex1,
FILENAME='E:\Data\AWSI1.NDF,
SIZE=2000,
FILEGROWTH=200),
LOG ON (
NAME=AWSampleLog
FILENAME='F:\Data\AWSLog1.LDF',
SIZE=200,
FILEGROWTH=20)
CHAPTER 4 n BACKING UP AND RESTORING FILES AND FILEGROUPS 76
This CREATE DATABASE statement creates the primary filegroup??”the primary filegroup
is named, aptly enough, PRIMARY??”and two additional filegroups, each containing a single
file initially. Notice from the names of the filegroups that the intent here is most likely to
separate clustered and nonclustered indexes for performance purposes. Also note: The
log file has no direct link to any particular filegroup.
nNote Each database must have a filegroup named PRIMARY that holds the .


Pages:
152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176