付録F.19 「LargeAddFiletoKdrive.sql」クエリスクリプト

USE [NETMDM_SAMPLE]
GO

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