付録F.16 「LargeAddFile.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 = 800GB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%
) TO FILEGROUP [netmdm_moni_dp_0001]
GO

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

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

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

ALTER DATABASE NETMDM_SAMPLE ADD FILE (
       NAME = N'NETMDM_DP_0005',
       FILENAME = N'I:¥NETMDP¥MONITOR_DP_0005.ndf',
       SIZE = 800GB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%
) TO FILEGROUP [netmdm_moni_dp_0005]
GO

ALTER DATABASE NETMDM_SAMPLE ADD FILE (
       NAME = N'NETMDM_DP_0006',
       FILENAME = N'J:¥NETMDP¥MONITOR_DP_0006.ndf',
       SIZE = 800GB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%
) TO FILEGROUP [netmdm_moni_dp_0006]
GO