Shrinking Security Center databases after an upgrade - Security Center 5.9

Security Center Administrator Guide 5.9

Applies to
Security Center 5.9
Last updated
2022-10-25
Content type
Guides > Administrator guides
Language
English
Product
Security Center
Version
5.9

After a database upgrade, disk usage might increase due to the temporary storage required to execute the upgrade transactions. The disk space used during the upgrade is not automatically released after the upgrade is complete. To reclaim the unused disk space, you must shrink the database.

Before you begin

Not all database upgrades cause the database to grow in size. If you are not sure whether or not you need to shrink your database after an upgrade, check the disk usage with SQL Server Management Studio.

What you should know

Depending on the recovery model of your database, a transaction log backup might be required to reclaim the unused disk space. For more information, see the following online articles:

Procedure

  1. Follow the Shrink a Database procedure from Microsoft.
  2. Repeat this procedure for all databases that require shrinking.