JP1/NETM/DM 構築ガイド (Windows(R)用)

[目次][用語][索引][前へ][次へ]

付録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