Job Management Partner 1/Software Distribution Setup Guide

[Contents][Glossary][Index][Back][Next]

Appendix F.16 LargeAddFile.sql query script

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