magritton
6/13/2015 - 2:00 AM

SQL Create file groups and file for SQL Server

SQL Create file groups and file for SQL Server

SQL FileGroup.sql
content_copyfile_download
use master
go
alter database dbPTest add FileGroup Sales_2010
alter database dbPTest add FileGroup Sales_2011
alter database dbPTest add FileGroup Sales_2012
alter database dbPTest add FileGroup Sales_2013
alter database dbPTest add FileGroup Sales_2014
alter database dbPTest add FileGroup Sales_2015
go
alter database dbPTest add file ( Name = sd_2010,filename = 'C:\pTestFG\sd_2010.ndf',size = 5mb, maxsize = 100mb, filegrowth = 5mb) to filegroup Sales_2010;
alter database dbPTest add file ( Name = sd_2011,filename = 'C:\pTestFG\sd_2011.ndf',size = 5mb, maxsize = 100mb, filegrowth = 5mb) to filegroup Sales_2011;
alter database dbPTest add file ( Name = sd_2012,filename = 'C:\pTestFG\sd_2012.ndf',size = 5mb, maxsize = 100mb, filegrowth = 5mb) to filegroup Sales_2012;
alter database dbPTest add file ( Name = sd_2013,filename = 'C:\pTestFG\sd_2013.ndf',size = 5mb, maxsize = 100mb, filegrowth = 5mb) to filegroup Sales_2013;
alter database dbPTest add file ( Name = sd_2014,filename = 'C:\pTestFG\sd_2014.ndf',size = 5mb, maxsize = 100mb, filegrowth = 5mb) to filegroup Sales_2014;
alter database dbPTest add file ( Name = sd_2015,filename = 'C:\pTestFG\sd_2015.ndf',size = 5mb, maxsize = 100mb, filegrowth = 5mb) to filegroup Sales_2015;