付録F.4 「AddFiletoFdrive.sql」クエリスクリプト

USE [NETMDM_SAMPLE]
GO

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

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

ALTER DATABASE NETMDM_SAMPLE ADD FILE (
       NAME = N'NETMDM_DP_0007',
       FILENAME = N'F:¥NETMDP¥MONITOR_DP_0007.ndf',
       SIZE = 80GB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%
) TO FILEGROUP [netmdm_moni_dp_0007]
GO

ALTER DATABASE NETMDM_SAMPLE ADD FILE (
       NAME = N'NETMDM_DP_0008',
       FILENAME = N'F:¥NETMDP¥MONITOR_DP_0008.ndf',
       SIZE = 80GB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%
) TO FILEGROUP [netmdm_moni_dp_0008]
GO