DOCID Error when upgrading from to SQL 2005 FTK Size

Hi,

How to determine the size of FTK, please help,

Since the DOCID map in SQL Server 2005 is stored in the database, the size requirement on the database side has increased, but has reduced on the full-text catalog side. If a database contains a full-text index, you need to ensure that the file group associated with the base table has enough space to accommodate the additional space requirement for full-text indexes. Use the following formula to estimate the space required.
(2*FTK+ 34bytes) * RC
Where:
FTK = Full-Text Key Size
RC = Row Count of the Table

thanks,

Imran.

Hello, I am going to move this thread over to SQL Server Database Engine, since you are more likely to get help on there. Thanks!|||

Imran,

What specific DOCID error did you get? The below text is directly from the SQL Server 2005 Upgrade Advisor Books Online (BOL) topic "Increase database size to accommodate DOCID map" Did you check the crawl log to identify the error and increase the space of the file group? Note, the craw log is located in the LOG directory on the server where you have installed SQL Server 2005.

Below are two additional references that might be helpful to you depending upon the DOCID error you are getting:

"Additional space requirement for Full-Text Search - Because the document identifier (DOCID) map in SQL Server 2005 is stored in the database, the size requirement on the database side has increased. However, the size requirement on the full-text catalog side has decreased." - from: Breaking Changes to Full-Text Search in SQL Server 2005
http://msdn2.microsoft.com/en-us/library/ms143709.aspx

See Step 10 and screenshot for SQL 2005 upgrade wizard (search on Docid to find it quickly) in:
http://h20331.www2.hp.com/ActiveAnswers/downloads/Migrate_SQL2005_Integrity_1005.pdf

Regards,
John
SQL Full Text Search Blog
http://jtkane.spaces.live.com/

|||I would also like to know how to determine the FTK size....