Solved

Sql Server 2005 DB with fulltext restore issue

Posted on 2009-07-03
4
200 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
spx for moving values to new table 5 76
CROSS APPLY 4 69
Clone table from one server.database to another server.database 24 57
What is GIS method of Geometry data type? 6 28
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

738 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