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

2012年3月21日星期三

Full Text Search

I have a strange issue with full text search. I have a table that has only 700 records in it, when I enable full text search and follow the wizard the index is not getting build. the storage full text say it is populating and it never does. I have restarted the service and rebuild the index few times with no benefits. I can do the same steps on another server with the same database and it works just fine. does anyone have any hints or things I can try? Please help

Check what are privileges associated with the login used to create this fulltext, also check whether MSsearch service is up and running.

Did you get any errors or warnings during thsi process?

|||

MSFTESQL is up and running. I don't get any errors when creating the Index. everything is successful status but when I am looking the property of the full text under storage the status is always "populating Catalog". The only error I can see is in the event viewer-

Performance Counters could not be loaded for msftesqlFD for instance MSSQLSERVER due to the following error: The system cannot find the file specified. 0x80070002.

not sure if this is related to full text search?

Please help.

2012年2月24日星期五

FULL Backup question

Hello everybody,
I am very newbie in sqlserver and I would to ask you a question.
I would like to backup my database through backup wizard and I would
like to automatic it for everyday full backup. What to you think it is
better database maintenance planner or backup wizard.
Could someone help me on that?
inaIf you are only doing a scheduling for a backup, I would use the richer
backup wizard rather than the maintainance wizard.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--|||so I need to go to tools/ database backups/ select database and the
device; in my case is file E:/... because you already do the full
backup or all server. I am learning SQL server and for the moment I do
not know scrpts very well so I do not want to do that at the moment.
It is true like this or Do I need to do others manipulations?
Ina

FULL Backup question

Hello everybody,
I am very newbie in sqlserver and I would to ask you a question.
I would like to backup my database through backup wizard and I would
like to automatic it for everyday full backup. What to you think it is
better database maintenance planner or backup wizard.
Could someone help me on that?
inaIf you are only doing a scheduling for a backup, I would use the richer
backup wizard rather than the maintainance wizard.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--|||so I need to go to tools/ database backups/ select database and the
device; in my case is file E:/... because you already do the full
backup or all server. I am learning SQL server and for the moment I do
not know scrpts very well so I do not want to do that at the moment.
It is true like this or Do I need to do others manipulations?
Ina