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. However, in the case
of the Archiver database upgrade from 5.3 to
5.8, we do
recommend shrinking the database after the upgrade. 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
-
Follow the Shrink a Database procedure from
Microsoft.
-
Repeat this procedure for all databases that require shrinking.