Thursday 30 March 2017

Windows 10 - how to reduce size of Datastore.edb example script and screenshots

Windows 10 - how to reduce size of Datastore.edb

ANSWER: defrag the database using esentutl.exe

Here's what I did

open up cmd as administrator
(click windows start and type cmd, right click command prompt and choose run as administrator)

Then in commmand prompt, which should already be at C:\Windows\system32>
type

esentutl /d C:\Windows\SoftwareDistribution\DataStore\DataStore.edb

Here's the output from the program

C:\WINDOWS\system32>esentutl /d C:\Windows\SoftwareDistribution\DataStore\DataStore.edb

Extensible Storage Engine Utilities for Microsoft(R) Windows(R)
Version 10.0
Copyright (C) Microsoft Corporation. All Rights Reserved.

Initiating DEFRAGMENTATION mode...
            Database: C:\Windows\SoftwareDistribution\DataStore\DataStore.edb

                  Defragmentation Status (% complete)

          0    10   20   30   40   50   60   70   80   90  100
          |----|----|----|----|----|----|----|----|----|----|
          ...................................................


Moving '.\TEMPDFRG18068.EDB' to 'C:\Windows\SoftwareDistribution\DataStore\DataStore.edb'... DONE!

Moving '.\TEMPDFRG18068.jfm' to 'C:\Windows\SoftwareDistribution\DataStore\DataStore.jfm'... DONE!

Note:
  It is recommended that you immediately perform a full backup
  of this database. If you restore a backup made before the
  defragmentation, the database will be rolled back to the state
  it was in at the time of that backup.

Operation completed successfully in 10.797 seconds.


C:\WINDOWS\system32>


Now i have an extra 1024MB free - makes the difference on windows10!