1 2 3 4 5 6 7 8 9 10 11 12 13
| CREATE DATABASE [OPTIM] ON PRIMARY
( NAME = N'F_PRIM_1', FILENAME = N'C:\DB\FP1' , SIZE = 25KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ),
FILEGROUP [FG_COM]
( NAME = N'F_COM_1', FILENAME = N'C:\DB\FC1' , SIZE = 256KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10240KB ),
( NAME = N'F_COM_2', FILENAME = N'C:\DB\FC21' , SIZE = 256KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10240KB ),
FILEGROUP [FG_DATA]
( NAME = N'F_DATA_1', FILENAME = N'C:\DB\FD1' , SIZE = 256KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10240KB ),
FILEGROUP [FG_INDEX]
( NAME = N'F_INDEX_1',FILENAME = N'C:\DB\FI1' , SIZE = 256KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10240KB )
LOG ON
( NAME = N'F_LOG_1', FILENAME = N'C:\DB\FL1' , SIZE = 256KB , MAXSIZE = 2048GB , FILEGROWTH = 10240KB ),
( NAME = N'F_LOG_2', FILENAME = N'C:\DB\FL2' , SIZE = 256KB , MAXSIZE = 2048GB , FILEGROWTH = 10240KB )
GO |
Partager