vfilby
vfilby

Reputation: 10008

Attaching DB with full-text catalogs under a different name?

I have a database with regular full-text catalogs. I want to detach this database, copy it to a different server and attach it under a different name (same name but with '_BAK' appended to it). I am using SQL Server 2005.

Here is the error trying to attach DATABASE with full-text catalogs under the name DATABASE_BAK

Warning: Identity or last population complete time of full-text catalog in 
directory 'E:\DATABASE\Name_FullText' does not match database 'DATABASE'. 
The full-text catalog cannot be attached.

Upvotes: 3

Views: 1916

Answers (1)

John Sansom
John Sansom

Reputation: 41899

Why not just attach the database and then rename it once attached?

Upvotes: 2

Related Questions