CREATE DATABASE [ORGANIZATION] CONTAINMENT = NONE ON PRIMARY ( NAME = N'ORGANIZATION', FILENAME = N'D:\SQLEXPRESSDATA\ORGANIZATION\ORGANIZATION.MDF' , SIZE = 520KB , MAXSIZE = UNLIMITED, FILEGROWTH = 64KB ), FILEGROUP [ORGANIZATION_DATA] ( NAME = N'ORGANIZATION_DATA', FILENAME = N'D:\SQLEXPRESSDATA\ORGANIZATION\ORGANIZATION_DATA.NDF' , SIZE = 1000KB , MAXSIZE = UNLIMITED, FILEGROWTH = 64KB ) LOG ON ( NAME = N'ORGANIZATION_LOG', FILENAME = N'D:\SQLEXPRESSDATA\ORGANIZATION\ORGANIZATION_LOG.LDF', SIZE = 520KB , MAXSIZE = 2000MB , FILEGROWTH = 64KB ) GO ALTER DATABASE ORGANIZATION SET SINGLE_USER GO ALTER DATABASE ORGANIZATION ADD FILEGROUP [ORGANIZATION_DATA2] GO ALTER DATABASE ORGANIZATION ADD FILE ( NAME = N'ORGANIZATION_DATA2', FILENAME = N'D:\SQLEXPRESSDATA\ORGANIZATION\ORGANIZATION_DATA2.NDF' , SIZE = 1000KB , MAXSIZE = UNLIMITED, FILEGROWTH = 64KB ) TO FILEGROUP [ORGANIZATION_DATA2] GO ALTER DATABASE ORGANIZATION SET MULTI_USER GO