How to resolve ss2008r2 errors 30064 and 17063?

Message text 30064, (severity 17): "SQL Server failed to set security information on the full-text FilterData directory in the FTData folder. Full-text indexing of some types of documents may fail until this issue is resolved. You will need to repair the SQL Server installation." And "Error: 50000 Severity: 16 State: 1 Error 4860, Level 16, State 1, Procedure -, Line 1, Message: Cannot bulk load." etc. Can find no answer anywhere. DB is installed on clustered instance running on windows server 2008 r2 os. Fulltext catalogue is installed on shared drive with system dbs; datestamp shows updated; Active Full Text Catalogue report shows status Available. No user complaints received...

more ▼

asked Sep 18, 2012 at 11:30 AM in Default

avatar image

10 1 1 1

Is there any further information in the SQL Server log files?

Sep 18, 2012 at 11:46 AM ThomasRushton ♦♦
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Check the path to the Full Text Data folders that are configured in the registry.

more ▼

answered Sep 18, 2012 at 11:48 AM

avatar image

ThomasRushton ♦♦
40k 20 49 52

No further info in sqlserver logs. Sorry to be dense, how do I check the ft path in the registry?

Sep 18, 2012 at 01:01 PM MIM

According to Google, you need to open your favourite Registry editor (regedit), and browse / navigate to:

 HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<instance id>\Setup\FullTextDefaultPath

where "instance id" is the, erm, name of your SQL Server instance that you're interested in.

Sep 18, 2012 at 03:05 PM ThomasRushton ♦♦

Thanks Thomas, FullTextDefaultPath recorded in registry matches location recorded in Database Properties..Files..Path and observed location of ndf file on server.

Sep 18, 2012 at 03:23 PM MIM
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Sep 18, 2012 at 11:30 AM

Seen: 3481 times

Last Updated: Sep 18, 2012 at 04:21 PM

Copyright 2016 Redgate Software. Privacy Policy