1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| -- créations de fichier dans les groupes de fichiers :
ALTER DATABASE MA_BASE
ADD FILE (NAME = 'F_DATA1',
FILENAME = 'E:\DATA\MA_BASE_DATA1',
SIZE = 100 GB,
FILEGROWTH = 250 MB)
TO FILEGROUP FG_DATA;
GO
ALTER DATABASE MA_BASE
ADD FILE (NAME = 'F_DATA2',
FILENAME = 'F:\DATA\MA_BASE_DATA2',
SIZE = 100 GB,
FILEGROWTH = 250 MB)
TO FILEGROUP FG_DATA;
GO
ALTER DATABASE MA_BASE
ADD FILE (NAME = 'F_INDXEX1',
FILENAME = 'G:\DATA\MA_BASE_INDEX1',
SIZE = 120 GB,
FILEGROWTH = 250 MB)
TO FILEGROUP FG_INDEX;
GO |
Partager