Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 206
  • Last Modified:

Sql Server 2005 DB with fulltext restore issue

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
duke63
Asked:
duke63
  • 2
  • 2
1 Solution
 
Jagdish DevakuSr DB ArchitectCommented:
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
 
duke63Author Commented:
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
 
Jagdish DevakuSr DB ArchitectCommented:
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
 
duke63Author Commented:
hi,
to avoid further "issues" we shift to sqlserver 2008 this weekend.
Anything works fine with a little increase in performance.
Thanks,
duke63
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now