Reputation: 10008
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
Reputation: 41899
Why not just attach the database and then rename it once attached?
Upvotes: 2