title: Attaching DB with full-text catalogs under a different name?
body: <p>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.</p>
  
  <p>Here is the error trying to attach DATABASE with full-text catalogs under the name DATABASE_BAK</p>
  
  <pre><code>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.
  </code></pre>
  
  <ul>
  <li>Is there a way to attach a database w/ full-text under a different name?</li>
  <li>If not what other options do I have?
  
  <ul>
  <li>Attach without fulltext?</li>
  <li>Drop the full-text at detach and recreate it? </li>
  </ul></li>
  </ul>