Solved

Sql Server 2005 DB with fulltext restore issue

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

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

Suggested Solutions

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

744 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now