title: SQL Server 2005: Attach database using sp_attach_db with full text catalog
body: <p>Having issues attaching a Database and full text catalog from server A to server B with the "sp_attach_db" command in SQL Server 2005 SP3. All the database files (data, log, full-text catalog) have been copied from server A to server B. I am guessing that this is indeed possible and that my syntax is just incorrect, but I can't seem to find any examples or good documentation anywhere. Here is some pseudo syntax I am using...</p>
  
  <pre><code>exec sp_attach_db '&lt;database_name&gt;', '&lt;database data file&gt;', '&lt;database full text catalog folder&gt;', '&lt;database log file&gt;'
  </code></pre>
  
  <p>or somewhat of an example....</p>
  
  <pre><code>exec sp_attach_db 'database', 'C:\Database\Data\database_data.mdf', 'C:\Database\Data\FTData', 'C:\Databases\Logs\database_log.ldf'
  </code></pre>
  
  <p>I get an error of "Unable to open the physical file" from this command and the attach command fails. If I remove the full text catalog folder from the sp_attach_db command the database mounts but gives me a warning that it couldn't find the full text catalog. What am I missing!?</p>