November 22, 2010 at 9:54 am
I'm upgrading a database from SQL 2005 to SQL 2008; the database has full text search enabled and several full-text catalogs.
Are there any additional steps I need to perform to upgrade this database to SQL 2008, apart from the usual steps of UPDATE USAGE, UPDATE STATISTICS?
Does FULL TEXT SEARCH require any additional consideration when upgrading from SQL 2005?
I'm new to FULL TEXT SEARCH, so any responses to this would be most welcome.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
November 22, 2010 at 12:43 pm
If, in your upgrade, you plan on performing a backup/restore to the new server. The full database backup will include the full-text catalog. This will assure that the Full-text catalogs get upgraded properly.
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
November 22, 2010 at 12:58 pm
Thank you, that's what I had gathered from reading BOL, I just wanted to make sure I understood correctly.
It seemed too good to be true... 🙂
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply