Solved

Sql Server 2005 DB with fulltext restore issue

Posted on 2009-07-03
4
199 Views
Last Modified: 2012-05-07
A very strange behavior and no idea where it comes from.
We have a productive sql server 2005 database and an identical database for development purposes both fulltext enabled.

Like with other databases we make a backup of the development DB and  restore the backup over the productive db.

We have identical DB paths and the ft catalog names and ids are the same.
We can see no differences between both instances.
Also deleting the productive DB first had no effect.

Problem:
Searching "where contains ' "DA=SPRITZE" ' has results in the dev DB but no results in productive DB.
Other contain statements are running correct.
It seems that the "=" is missinterpreted somehow?
Searches with german umlauts are running correct too!

Any idea
duke63



0
Comment
Question by:duke63
  • 2
  • 2
4 Comments
 
LVL 14

Expert Comment

by:Jagdish Devaku
ID: 24771767
hi,
normally fulltext catalog will not restore with regular backups. there will be always some issues with this.
when ever you restore a db, its better to delete and recreate the full text catalogs which is quite easy.
for more infor on moving or restoring the full text catalog, refer to the following link:
http://support.microsoft.com/kb/240867
bye.
0
 

Author Comment

by:duke63
ID: 24772026
Hi JagdishDevaku,
isnt the fulltext backup and restore capability part of sql server 2005?
Your link refers to sql server 2000?
Do you mean with "allways issues" that it is part of backup and restore but one should better use your suggested way?
As i sad we did handle this with another database for years without problems.
Isnt there another way to move fulltext cats without using the "registry"?

Thanks,
duke63


0
 
LVL 14

Accepted Solution

by:
Jagdish Devaku earned 500 total points
ID: 24772074
hi,
moving the full text catalogs can also be done using backup restore but before restoring the backup you need to copy the files in full text catalog to the new server and then start the restore.
if this is not helpful... then drop & recreate the full text catalog.
check the below links for restoring full text catalogs:
http://sqlserverpedia.com/wiki/FTS_-_Restoring_&_Relocating_your_Catalogs
http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/4285fe4c-fd9a-4d8f-862c-cc3bb698dd0c
http://stackoverflow.com/questions/206184/move-copy-sql-server-2005-full-text-index
please let me know if there is any issue.
bye.
0
 

Author Closing Comment

by:duke63
ID: 31599519
hi,
to avoid further "issues" we shift to sqlserver 2008 this weekend.
Anything works fine with a little increase in performance.
Thanks,
duke63
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question