WSS Search fills 10 GB limit on SBS server 2011

Posted by Kactus on Server Fault See other posts from Server Fault or by Kactus
Published on 2011-08-30T04:15:57Z Indexed on 2012/09/03 15:40 UTC
Read the original article Hit count: 350

I've got a SBS Server 2011 Standard SP1 that isn't very busy. 2 Users local and 2 remote. We have sharepoint that has maybe a dozen small documents at most.

I've just started getting the following two error occur

Could not allocate space for object 'dbo.MSSBatchHistory'.'IX_MSSBatchHistory' in database 'WSS_Search_SERVER' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

And

CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 10240 MB per database.

Digging around in SQL manager I see that WSS Search DB file size is 10241MB, the log file is only 147 MB

Firstly, why is WSS Search taking up so much space? How can I stop it from doing so, and what can I do now to get things running ok. I know about log file truncating and this isn't the case here since the log is tiny.

Any help is appreciated. There is plenty of free space on the disk (791GB free)

Thanks Kactus

© Server Fault or respective owner

Related posts about sql-server

Related posts about sharepoint