How to reduce "windows.edb" size or limit it

Hi,

We are running Windows Server 2016 as a Terminal Service. We need to enable windows search service as users outlook also configure on each terminal session. Every 30-45 days "windows.edb" is 180GB. I have to delete the file to make space in C drive. If we disable windows search than users are not able to search anything on server and outlook.

Is there any permanent solution except increase the C drive disk space or move "windows.edb" into another drive. How to reduce "windows.edb" size or limit it?

Thanks in Advance.
GeforceAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JohnBusiness Consultant (Owner)Commented:
That is your mail file and deleting stuff in it will limit users as you note.

Accordingly, you need to add space (and I suggest lots) to your server.
GeforceAuthor Commented:
Hi John,

Thanks for the reply but C drive already have 400GB size and no matter how big the C drive windows.edb will consume all the space. I hope, there is some solution where we restrict windows.edb file to grow.
Devin BeckerIdentity Management and SecurityCommented:
The Windows.edb is a database file of the Windows Search service, which provides content indexing, property caching, and search results for files, e-mail, and other content.

So as you know, since the Windows.edb file will continue to grow in size, the best bet to avoid problems for end users would be to index the file in another drive. which can be done as follows:

open Control Panel > Indexing Options > Advanced > Index location > Select new.

There are also options to defragment the database using esentutl.exe, but moving the database location sounds like the best option for you and you end users.

Hope this helps,

Devin Becker
DevOps Associate @ EE
 Acronis Global Cyber Summit 2019 in Miami

The Acronis Global Cyber Summit 2019 will be held at the Fontainebleau Miami Beach Resort on October 13–16, 2019, and it promises to be the must-attend event for IT infrastructure managers, CIOs, service providers, value-added resellers, ISVs, and developers.

JohnBusiness Consultant (Owner)Commented:
Maybe put mail on another drive that is at least a Terabyte and possibly more
Devin BeckerIdentity Management and SecurityCommented:
Also worth noting, there was a patch that server 2012 had that prevented  this kind of growth of that file, however, I have not been able to find a patch for such problem on server 2016.

If I find something I will make sure to let you know here.

EDIT: Alternatively, you could write a script that you could put on a schedule to delete and rebuild the index so that the size stays lower, however, it's kind of just a bandage for now. Nothing I've found seems concrete in fixing this specific issue "permanently"

Devin Becker
DevOps Associate @ EE
Shaun VermaakTechnical SpecialistCommented:
So you don't want to disable search, don't want to increase the drive and do not want to move it to another drive.

Your only option is to reduce the items being indexed or periodically defrag the edb

sc config wsearch start=disabled
sc stop wsearch
esentutl.exe /d %AllUsersProfile%\Microsoft\Search\Data\Applications\Windows\Windows.edb
sc config wsearch start=delayed-auto
sc start wsearch

Open in new window

http://woshub.com/windows-edb-file-too-big-how-to-reduce-size/
McKnifeCommented:
Since I administered a file server index for a long time, I can tell you that 180 GBs is incredibly large for a single server. May I ask how big the folders are that are being indexed? How many TB?
GeforceAuthor Commented:
Hi,
Please close the ticket. Shaun Vermaak and Devin Becker suggestion is helpful.
Thanks guys for your replies.
McKnifeCommented:
Geforce, please close this question, you as author are supposed to do it by selecting helpful comments and selecting comments that led to a solution as solution. If you found your own solution, please share it and select that as solution.
GeforceAuthor Commented:
I already selected helpful comments.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2016

From novice to tech pro — start learning today.