USE [master] GO --我们创建包含PRIMARY分区在内一共3分区的数据库 CREATE DATABASE [db_partition_test] ON PRIMARY ( NAME = N'db_partition_test', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data/db_partition_test.mdf' ), FILEGROUP [FG1] ( NAME = N'db_partition_test_fg1_1', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data/db_partition_test_fg1_1.ndf' ), FILEGROUP [FG2] ( NAME = N'db_partition_test_fg2_1', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data/db_partition_test_fg2_1.ndf' ) LOG ON ( NAME = N'db_partition_test_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data/db_partition_test_log.ldf' ) GO USE [db_partition_test] GO --创建分区函数,分区范围为 id |