March 17, 2008 at 8:54 am
after restoring a sql 2000 db on sql 2005 instance I am getting following error message when trying to check the properties of a fulltext catalog:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Property FullTextIndexSize is not available for FullTextCatalog '[idxCandidates]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)
db compatibility is 90. any ideas what's the workaround?
thanks
March 17, 2008 at 8:58 am
After restoring database from 2000 to 2005 which had a full text catalog. you have to rebuild FTC again on the new server (2005). It won't get created by itself, unlike table indexes. Expand database in Management studio and check FTC in storage. Right click and then rebuild.
I found it takes longer time in 2005 to rebuild FTC than compared to 2000 and the FTC size also varies in both version.
SQL DBA.
March 17, 2008 at 9:08 am
I tried doing that. the problem is catalog was initially build on a drive that doesnt exist on this machine. and when I click properties i get the error message listed above. so I am not sure how to change the path.. is there any other way to change the path and so that I can rebuild afterwards?
March 17, 2008 at 11:30 am
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply