付録F.3 「AddFiletoEdrive.sql」クエリスクリプト

USE [NETMDM_SAMPLE]
GO

ALTER DATABASE NETMDM_SAMPLE ADD FILE (
       NAME = N'NETMDM_DP_0001',
       FILENAME = N'E:¥NETMDP¥MONITOR_DP_0001.ndf',
       SIZE = 80GB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%
) TO FILEGROUP [netmdm_moni_dp_0001]
GO

ALTER DATABASE NETMDM_SAMPLE ADD FILE (
       NAME = N'NETMDM_DP_0002',
       FILENAME = N'E:¥NETMDP¥MONITOR_DP_0002.ndf',
       SIZE = 80GB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%
) TO FILEGROUP [netmdm_moni_dp_0002]
GO

ALTER DATABASE NETMDM_SAMPLE ADD FILE (
       NAME = N'NETMDM_DP_0003',
       FILENAME = N'E:¥NETMDP¥MONITOR_DP_0003.ndf',
       SIZE = 80GB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%
) TO FILEGROUP [netmdm_moni_dp_0003]
GO

ALTER DATABASE NETMDM_SAMPLE ADD FILE (
       NAME = N'NETMDM_DP_0004',
       FILENAME = N'E:¥NETMDP¥MONITOR_DP_0004.ndf',
       SIZE = 80GB,MAXSIZE = UNLIMITED,FILEGROWTH = 10%
) TO FILEGROUP [netmdm_moni_dp_0004]
GO