Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Which one is at the top of the hierarchy?
Message
De
10/01/2010 19:32:38
 
 
À
10/01/2010 19:18:37
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01443158
Message ID:
01443167
Vues:
24
>>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform