SQL Server 2008R2 table partition splitting problem

Problem Description:

The automatic talent zone for the TAB1 table is automatically generated by SQL Server Agent-job 00:00 points per day;

Because the database service was stopped, SQL Server Agent service forgot to open, resulting in no new partition 00:00 that day;

Results in 2 days of data being in a partition.

Workaround :

Create a new filegroup, file, or add a boundary to the partition function to split the partition that originally saved 2 days of data:

Split Code :

Alter PARTITION function Pfunc_time ()--pfunc_time () partition functions
Split Range (N ' 2015-06-04 00:00:00.000 ')-adds a partition boundary to split the original partition into 2 partitions

SQL Server 2008R2 table partition splitting problem