Archiving a partition
Incident partitions fill automatically, but you can only keep either 4 partitions (SQL Server Express) or 8 partitions (Microsoft SQL Server Standard or Enterprise) online. To save older partitions, archive them offline. The maximum local offline storage allowed is 12 partitions (approximately 3 years of records). To archive a partition:
Steps
Next steps
The number of partition archives you can create depends on the size of the partition location.