Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Which one is at the top of the hierarchy?
Message
 
 
To
10/01/2010 19:18:37
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01443158
Message ID:
01443167
Views:
25
>>I believe Filegroup can have multiple files.
>
>That's what I think as well. It is quite confusing however that SSMS lists both in reverse.

In the link I gave you earlier:

------------
How can I add files to a filegroup?

ALTER DATABASE CustomerDB_OLD
ADD FILE
(
NAME = FG_READONLY1,
FILENAME = 'C:\CustDB_RO.ndf',
SIZE = 5MB,
MAXSIZE = 100MB,
FILEGROWTH = 5MB
) TO FILEGROUP FG_READONLY;
GO
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform