Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Moving a database using backup/restore method causing problems Expand / Collapse
Author
Message
Posted Tuesday, January 18, 2011 8:53 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, January 14, 2014 6:06 PM
Points: 146, Visits: 1,448
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.
Post #1049429
Posted Tuesday, January 18, 2011 11:12 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, January 14, 2014 6:06 PM
Points: 146, Visits: 1,448
I changed the Full-Text Upgrade Option to Rebuild from Import to see if that changes anything.
Post #1049546
Posted Wednesday, April 17, 2013 1:32 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, September 5, 2014 8:55 AM
Points: 417, Visits: 867
I am running in to similar issue with FT GATHERER running and log growing. Did you ever find a solutions to this?
Post #1443474
Posted Friday, April 26, 2013 2:19 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
what is compatibility settings?.



Regards
Durai Nagarajan
Post #1446844
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse