Maintenance Activities

The following maintenance activities are recommended before and after partitioning the table. These activities may take some time (30 minutes to a few hours) based on the size of the database.

Before partitioning

• Backup the database.

After Partitioning

• Improve overall performance by optimizing the database as follows:

1. Shrink the primary database file.

2. Shrink the log file.

3. Rebuild indexes.

Backup and Restoring Partitioned Database

Backup and restoring steps for partitioned database is slightly different from the standard database backup and restoration. Please follow the Microsoft documentation for details.

Following references may help for backup and restoration of Database with Partition:

https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/restore-and-recovery-overview-sql-server?view=sql-server-2017

https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/example-piecemeal-restore-of-only-some-filegroups-simple-recovery-model?view=sql-server-2017