Welcome to the blog of mechanised.com

This blog is mainly a technical repository of information on Virtualisation tools and management for our hosting service.

Also for HP's Bladesystem that we use at both our datacentres.

Other articles are also included on .Net development and MS SQL Server as well as other interesting things we come across.

Tuesday, 29 March 2011

Moving FT catalogs from SQL 2005 to SQL 2008

Ok, so you want to migrate your FT catalogs from the SQL 2005 folders to new ones in SQL 2008.

When you detach DB from 2005 make sure you select the option to save the FT catalogs.

Move the physical catalog files to the new path for SQL 2008, to see where they currently are try this:

select * from sys.master_files where type = 4

When reattaching SQL 2008 will complain the files are not found so then point to the new locations and it should all work fine!