CODEWITHSUNDEEP
sqlsql-serversql-server-2005
Ron Skufca
Ron Skufca

Reputation: 2078

Move/copy SQL Server 2005 full text index

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?

Upvotes: 1

Views: 4052

Answers (3)

Ron Skufca
Ron Skufca

Reputation: 2078

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.

Upvotes: 0

Craig
Craig

Reputation: 36856

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.

Upvotes: 1

Josef
Josef

Reputation: 7609

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.

Upvotes: 0

Related Questions