July 22, 2008 at 4:23 pm
Gurus,
we are migrating some of the databases from server A(sql 2000) to server B(sql 2005). Now my question is i have a database which has full text indexes on sql 2000, i am using attach-detach for the migration.. Do i neeed to pay any special attention for this database.. or any of you have a better procedure for the above requirement based on your earlier implementaions...
also i am aware of scrpting the full text indexes dropping them at source attaching the db at destination and running back the script..
all your suggestions are welcomed!!
July 22, 2008 at 6:28 pm
Need to repopulate full-text catalogs
BOL: How to: Upgrade to SQL Server 2005 (Setup)
More details: SQL Server 2005 Upgrade Technical Reference Guide
Pay attention to MSSearch service account in SQL2005
July 23, 2008 at 9:57 pm
I had many problems with this exact scenario. I was able to waggle enough downtime to repopulate everything fresh on the 2005 instance.
July 26, 2008 at 4:38 am
Thanks for the inputs guys..
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply