sqlserver分区问题

最新推荐文章于 2022-02-18 16:53:19 发布

磊子-许

最新推荐文章于 2022-02-18 16:53:19 发布

阅读量558

点赞数

分类专栏： server 文章标签： sqlserver

本文链接：https://blog.csdn.net/xuhualei88/article/details/41081947

版权

server 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

sqlserver修改user_message分区表
分区组和分区文件
ALTER DATABASE [BI_Baihe] ADD FILEGROUP [User_MessageFG2015M01]
ALTER DATABASE [BI_Baihe] ADD FILEGROUP [User_MessageFG2015M02]
ALTER DATABASE [BI_Baihe] ADD FILE ( NAME = N'User_Message2015M01', FILENAME = N'E:\BIDataBases\User_Message\User_MessageFG2015M01.ndf' , SIZE = 5683392KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10% )
TO FILEGROUP [User_MessageFG2015M01]
ALTER DATABASE [BI_Baihe] ADD FILE ( NAME = N'User_Message2015M02', FILENAME = N'E:\BIDataBases\User_Message\User_MessageFG2015M02.ndf' , SIZE = 5683392KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10% )
TO FILEGROUP [User_MessageFG2015M02]
处理分区方案和分区函数
use BI_baihe
go
alter partition scheme SendDatePS next used [User_MessageFG2015M01]
alter partition function SendDatePF() split range(N'2015-01-01T00:00:00.000')
go

alter partition scheme SendDatePS next used [User_MessageFG2015M02]
alter partition function SendDatePF() split range(N'2015-02-01T00:00:00.000')