显示标签为“stuff”的博文。显示所有博文
显示标签为“stuff”的博文。显示所有博文

2012年3月29日星期四

Full Text shutdown status

I have a large full text index (30 millions records) that is
populating on a live server (they are just doing without the full text
search stuff for now) and the index goes into shutdown mode. What is
that? Last time it did this i stopped and started the mssearch
service and it started back up again. The only problem is that when
it completed last time the number of records in the index was like 8
million. I did a test and a bunch of the rows did not get into the
population even though it supposedly finished correctly. So I am
hesitant to restart the service since I'm afriad it will not
completely fill the index again.
This is SQL 2000 on a Windows 2003 entprise box. But not in a
cluster. It's a stand alone machine. 4 proc, 16 gigs on the machine.
13 of the gigs used by sql. The box does stay pretty busy but not
completely bogged down.
Ryan
are there any event messages in the application log from MSSearch or MSSCI?
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"RyanOly" <ryanoly@.gmail.com> wrote in message
news:661760f9.0407141123.66388c39@.posting.google.c om...
> I have a large full text index (30 millions records) that is
> populating on a live server (they are just doing without the full text
> search stuff for now) and the index goes into shutdown mode. What is
> that? Last time it did this i stopped and started the mssearch
> service and it started back up again. The only problem is that when
> it completed last time the number of records in the index was like 8
> million. I did a test and a bunch of the rows did not get into the
> population even though it supposedly finished correctly. So I am
> hesitant to restart the service since I'm afriad it will not
> completely fill the index again.
> This is SQL 2000 on a Windows 2003 entprise box. But not in a
> cluster. It's a stand alone machine. 4 proc, 16 gigs on the machine.
> 13 of the gigs used by sql. The box does stay pretty busy but not
> completely bogged down.
> Ryan

2012年2月24日星期五

Full cycle database

New to the database stuff.........
What is 'Full cycle' mean for a database ?
Is there a web site where I can get more info '
Thanks.That is not a generally accepted term, an indeed no term I've encountered. C
an you post a context or a quote?
It *might* mean re-starting SQL Server, but without a context I can't tell.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"NTB22" <anonymous@.discussions.microsoft.com> wrote in message news:c57001c48a1a$321423e0$a5
01280a@.phx.gbl...
> New to the database stuff.........
> What is 'Full cycle' mean for a database ?
> Is there a web site where I can get more info '
> Thanks.

Full cycle database

New to the database stuff.........
What is 'Full cycle' mean for a database ?
Is there a web site where I can get more info '
Thanks.That is not a generally accepted term, an indeed no term I've encountered. Can you post a context or a quote?
It *might* mean re-starting SQL Server, but without a context I can't tell.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"NTB22" <anonymous@.discussions.microsoft.com> wrote in message news:c57001c48a1a$321423e0$a501280a@.phx.gbl...
> New to the database stuff.........
> What is 'Full cycle' mean for a database ?
> Is there a web site where I can get more info '
> Thanks.

Full cycle database

New to the database stuff.........
What is 'Full cycle' mean for a database ?
Is there a web site where I can get more info ?
Thanks.
That is not a generally accepted term, an indeed no term I've encountered. Can you post a context or a quote?
It *might* mean re-starting SQL Server, but without a context I can't tell.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"NTB22" <anonymous@.discussions.microsoft.com> wrote in message news:c57001c48a1a$321423e0$a501280a@.phx.gbl...
> New to the database stuff.........
> What is 'Full cycle' mean for a database ?
> Is there a web site where I can get more info ?
> Thanks.