January 18, 2011 at 8:53 am
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.
January 18, 2011 at 11:12 am
I changed the Full-Text Upgrade Option to Rebuild from Import to see if that changes anything.
April 17, 2013 at 1:32 pm
I am running in to similar issue with FT GATHERER running and log growing. Did you ever find a solutions to this?
April 26, 2013 at 2:19 am
what is compatibility settings?.
Regards
Durai Nagarajan
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply