Solved

Sql Server 2005 DB with fulltext restore issue

Posted on 2009-07-03
4
198 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
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…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

808 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