Restoring a db with full text catalog/index from sql 2008 to sql 2014

• SQL!$@w$0ME

  SSChampion

  Points: 12349

  More actions

  August 6, 2015 at 8:44 pm

  #306409

  Hello Guys:

  I need to restore a SQL 2008 db on SQL 2014 instance with out upgrading the database(changing compatibility level). This database has full text enabled. I see one full text catalog an 2 full text indexes.

  Do I need to worry about anything or can I perform a clean restore from the backup with full text import?

  Do I need to rebuild the catalog in this case?

  Many thanks!

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738917

  More actions

  August 7, 2015 at 10:20 am

  #1818203

  1. Always worry. You should be fine, but if you aren't looking, you'll have issues. Try checking this: https://msdn.microsoft.com/en-us/library/ms142490.aspx

  2. I think you should be OK, but I'd prep clients that you might need to.