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
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. "Jorge Vinuales" wrote in message news:egmNfQQ4IHA.5012@TK2MSFTNGP02.phx.gbl... > 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 > >
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. "Hilary Cotter" escribió en el mensaje news:265F65EB-8538-4105-825D-57DB06C11A8F@microsoft.com... > 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. > > > "Jorge Vinuales" wrote in message > news:egmNfQQ4IHA.5012@TK2MSFTNGP02.phx.gbl... >> 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 >> >> >
As binary data is indexed it is stored on the c drive momentarily. "Jorge Vinuales" wrote in message news:OqxL%23PR4IHA.2332@TK2MSFTNGP03.phx.gbl... > 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. > > > "Hilary Cotter" escribió en el mensaje > news:265F65EB-8538-4105-825D-57DB06C11A8F@microsoft.com... >> 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. >> >> >> "Jorge Vinuales" wrote in message >> news:egmNfQQ4IHA.5012@TK2MSFTNGP02.phx.gbl... >>> 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 >>> >>> >> > >
