Follow

ESM - Shrink Database and Database Files

SQL Express has a limitation of 10GB database size. If the database reaches this size, it can impact the system. This is how you shrink the database and solve this issue.

Open up SQL Server Management Studio on the ESM Archive server:

mceclip0.png

Log into the Server with Windows Authentication credentials or "sa" login:

mceclip1.png

Expand the Databases tree and you should see ESM5_2. If this server is also a Management server, you will also see ESM5_2_Central:

mceclip2.png

Right click on ESM5_2 and choose Tasks/Shrink/Database:

mceclip3.png

On the box which pops up, click OK to launch the database cleanup task. This can take between 1 min to 5 mins depending on database size.

mceclip4.png

Once this is complete, perform the same task on Files instead of Database:

mceclip5.png

This will keep your database size in good shape, and avoid issue which occur when the database reaches too large a size.

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments