mdf file. That filegroup
cannot be renamed or deleted.
If you want to add a third filegroup after the database is created, possibly to hold
read-only data, you could use an ALTER DATABASE statement to do so:
ALTER DATABASE AWSample
ADD FILEGROUP AWSampleROData;
GO
This, of course, creates an empty filegroup. You still need to assign files to it:
ALTER DATABASE AWSample
ADD FILE (
NAME=AWSampleROData1,
FILENAME='D:\Data\AWSRO1.NDF',
SIZE=2000,
FILEGROWTH=200)
TO FILEGROUP AWSampleROData;
GO
The T-SQL commands to create a filegroup and assign specific files to that filegroup
are simple enough, but if you??™re syntactically challenged like I am, you can create filegroups
easily from SQL Server Management Studio, as shown in Figure 4-1. You can add
more than one filegroup at a time, but you must hit the OK button??”not the Add
button??”for the creation to take place.
CHAPTER 4 n BACKING UP AND RESTORING FILES AND FILEGROUPS 77
Figure 4-1. The SQL Server Management Studio interface for creating filegroups
At this point, the filegroups have no files associated with them.
Pages:
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177