I have a SQL 2005 SP3 database that has a full-text index. I do a full backup and then restore that backup with move to my SQL 2008 R2 server. The restore appears to be successful but then the log file starts to grow. I run a t-log backup and it does not truncate the log. dbcc opentran shows an index rebuld happening on that database. Confio IgniteFree points it to FT Gatherer running. An attempt to take the database offline and/or delete the database shows an error and points to proces -2.
Any ideas? If I can get this database moved I can retire this 2005 server because it's my last database on there.