Job Management Partner 1/Software Distribution Setup Guide

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

Appendix F.8 AddFiletoGdrive.sql query script

USE [NETMDM_SAMPLE]
GO
 
ALTER DATABASE NETMDM_SAMPLE ADD FILE (
        NAME = N'NETMDM_DP_0009',
        FILENAME = N'G:\NETMDP\MONITOR_DP_0009.ndf',
        SIZE = 80GB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%
) TO FILEGROUP [netmdm_moni_dp_0009]
GO
 
ALTER DATABASE NETMDM_SAMPLE ADD FILE (
        NAME = N'NETMDM_DP_0010',
        FILENAME = N'G:\NETMDP\MONITOR_DP_0010.ndf',
        SIZE = 80GB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%
) TO FILEGROUP [netmdm_moni_dp_0010]
GO
 
ALTER DATABASE NETMDM_SAMPLE ADD FILE (
        NAME = N'NETMDM_DP_0011',
        FILENAME = N'G:\NETMDP\MONITOR_DP_0011.ndf',
        SIZE = 80GB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%
) TO FILEGROUP [netmdm_moni_dp_0011]
GO
 
ALTER DATABASE NETMDM_SAMPLE ADD FILE (
        NAME = N'NETMDM_DP_0012',
        FILENAME = N'G:\NETMDP\MONITOR_DP_0012.ndf',
        SIZE = 80GB, MAXSIZE = UNLIMITED, FILEGROWTH = 10%
) TO FILEGROUP [netmdm_moni_dp_0012]
GO