I have a database with regular full-text directories. I want to separate this database, copy it to another server and attach it under a different name (same name, but with _ _BAK added to it). I am using SQL Server 2005.
Here is an error trying to attach a full-text catalog database named 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.
- Is there a way to bind a full-text database under a different name?
- If there are no other options?
- Attach without full text
- Discard the full text when disconnecting and recreate it?
source
share