There is no enough storage space available... error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jorge Vinuales - 08 Jul 2008 15:08 GMT

Hi friends, and sorry for my english.

I have a SQL Server 2000 with severals databases which hold more than 210
full text catalogs.

Recently, after create the last 3 DBs with 10 catalogs each, when the
Mssearch service populates the catalogs, I am getting the following error in
the application viewer: "Can not continue... There is no enough storage
space available".
The disc which support the full text catalogs files has more than 150 Gb. of
free space.

The current size of all files from all the catalogs is about 2.0 Gb.

Any help?

It seems like SQL Server has a limit in the disk space that can be used for
manage the catalog's files?

thanks

Reply to this Message

Hilary Cotter - 08 Jul 2008 15:51 GMT

How much space is on your c drive? MSSearch uses up some space on the c
drive - this is where the problem might be.

Also, why do you have so many full-text catalogs. You should have far less
for only "several" databases.

> Hi friends, and sorry for my english.
>
[quoted text clipped - 16 lines]
>
> thanks

Reply to this Message

Jorge Vinuales - 08 Jul 2008 17:02 GMT

Hi Hilary.

Thanks for your answer.

I'm not in front of my server right now, but I know that there is low space
in C drive. I didn't know that Mssearch use C drive.
This could be probably the cause. I will look tomorrow and will inform you.

How much space do you think is it needed en C drive? What kind of operations
take place with that drive?
All of my FT data are in another drive.

About the amount of catalogs, I think like you but i have not developed the
application. I'm just the db administrator and I think that it is not
necessary hold so many catalogs but they are there and i can't do anything.

Thank you for your advise. I will tell you about the solution.

> How much space is on your c drive? MSSearch uses up some space on the c
> drive - this is where the problem might be.
[quoted text clipped - 22 lines]
>>
>> thanks

Reply to this Message

Hilary Cotter - 08 Jul 2008 17:24 GMT

As binary data is indexed it is stored on the c drive momentarily.

> Hi Hilary.
>
[quoted text clipped - 42 lines]
>>>
>>> thanks

Reply to this Message