1-setupCoreSpace

USE [master]
GO

ALTER DATABASE [RIDW] ADD FILEGROUP [VNF_32K]
GO

ALTER DATABASE [RIDW] ADD FILEGROUP [VNF_IDX]
GO

ALTER DATABASE [RIDW] ADD FILEGROUP [VSTR_32K]
GO

ALTER DATABASE [RIDW] ADD FILEGROUP [VSTR_IDX]
GO

USE [master]
GO

ALTER DATABASE [RIDW] ADD FILE ( NAME = N'VNF_32K', FILENAME = N'C:\jazzdw\VNF_32K.ndf' , SIZE = 51200KB , FILEGROWTH = 51200KB ) TO FILEGROUP [VNF_32K]
GO

ALTER DATABASE [RIDW] ADD FILE ( NAME = N'VNF_IDX', FILENAME = N'C:\jazzdw\VNF_IDX.ndf' , SIZE = 51200KB , FILEGROWTH = 51200KB ) TO FILEGROUP [VNF_IDX]
GO

ALTER DATABASE [RIDW] ADD FILE ( NAME = N'VSTR_32K', FILENAME = N'C:\jazzdw\VSTR_32K.ndf' , SIZE = 51200KB , FILEGROWTH = 51200KB ) TO FILEGROUP [VSTR_IDX]
GO

ALTER DATABASE [RIDW] ADD FILE ( NAME = N'VSTR_IDX', FILENAME = N'C:\jazzdw\VSTR_IDX.ndf' , SIZE = 51200KB , FILEGROWTH = 51200KB ) TO FILEGROUP [VSTR_IDX]
GO

ALTER DATABASE [RIDW] ADD FILE ( NAME = N'VSTR_32K2', FILENAME = N'C:\jazzdw\VSTR_32K2.ndf' , SIZE = 51200KB , FILEGROWTH = 51200KB ) TO FILEGROUP [VSTR_32K]
GO