We are moving our database server to a bigger box. I have several databases with full text indexes. What is the best way to move the full text indexes?
A:
If you are moving the databases, move the folders that contain the FTS information and you should be fine.
If you're doing a restore, you should be fine as is.
Josef
2008-10-15 20:13:56
+1
A:
I find backup and restore is the only reliable way to move databases. The FTS should move with it when you do that. Detaching and reattaching databases never really sits well with me.
Craig
2008-10-15 20:22:26
A:
My first attempt was to copy over the database files and reattach them. I ran into the following error when attempting to access the catalog:
Full-text catalog 'database name' is in an unstable state. Drop and re-create this full-text catalog. (Microsoft SQL Server, Error: 7624
My second and Successful attempt was to restore the database from backup as Craig suggested. My catalog did come over but I received the following error:
Property IsAccentSensitive is not available for FullTextCatalog '[CatalogName]'" This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)
After a quick google search I found the answer MS KB 910067
Simply detach and reattach the database and I was fine.
Ron Skufca
2008-10-15 21:08:35
A:
Hi I'm having some difficulties with restoring a database which has full text index to anothe server. What are the steps I need to take in order to restore this database? When restoring, do I need to specify the full text file/folder name??? or just specify the database data and log file and rest is taked care of by the SQL server?
Thanks in advanc for any help