|
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:BIDataBasesUser_MessageUser_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:BIDataBasesUser_MessageUser_MessageFG2015M02.ndf',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')
（编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
