Microsoft® SQL Server® 2012 Bible

1119

Chapter 49: Partitioning

49

GO

ALTER DATABASE AdventureWorks

ADD FILEGROUP AdventureWorks_SalesOrderDetail2006Partition

GO

ALTER DATABASE AdventureWorks

ADD FILE

(

NAME = 'AdventureWorks_SalesOrderDetail2006Partition',

FILENAME = 'C:\SQLData\

AdventureWorks2008R2_SalesOrderDetail2006Partition.ndf',

SIZE = 10,

MAXSIZE = 120,

FILEGROWTH = 10

)

TO FILEGROUP AdventureWorks_SalesOrderDetail2006Partition

GO

ALTER DATABASE AdventureWorks

ADD FILEGROUP AdventureWorks_SalesOrderDetail2007Partition

GO

ALTER DATABASE AdventureWorks

ADD FILE

(

NAME = 'AdventureWorks_SalesOrderDetail2007Partition',

FILENAME = 'C:\SQLData\

AdventureWorks2008R2_SalesOrderDetail2007Partition.ndf',

SIZE = 10,

MAXSIZE = 120,

FILEGROWTH = 10

)

TO FILEGROUP AdventureWorks_SalesOrderDetail2007Partition

GO

ALTER DATABASE AdventureWorks

ADD FILEGROUP AdventureWorks_SalesOrderDetail2008Partition

GO

ALTER DATABASE AdventureWorks

ADD FILE

(

NAME = 'AdventureWorks_SalesOrderDetail2008Partition',

FILENAME = 'C:\SQLData\

AdventureWork_SalesOrderDetail2008Partition.ndf',

SIZE = 10,

MAXSIZE = 120,

FILEGROWTH = 10

)

TO FILEGROUP AdventureWorks_SalesOrderDetail2008Partition

c49.indd 1119c49.indd 1119 7/31/2012 10:24:23 AM7/31/2012 10:24:23 AM

http://www.it-ebooks.info