SQLTeam.com | Weblogs | Forums

Filestreaming and Filetables


#1

I've got myself in a pickle.

SQL Server 2012 64 bit on Windows 7

I enabled filestreaming (via SQL Server Configuration)
against a shared folder 'FS'.

Then I configure streaming in TSQL:
EXEC sp_configure filestream_access_level, 2
RECONFIGURE

Next I created a database and within that a filetable with
directory 'DS'. All fine. 'DS' is within 'FS'. I put some
documents in 'DS'. I was able to run queries over the
filetable and look at it's document store. All good.

Then I realise that I actually want the documents in a
different folder. So I delete the database and try, via
SQL Server Configuration, to change the name of the shared
folder. No luck. I rerun TSQL reconfigure filestream all
ways but whatever I do when going to SQL Server Config
and filestream there's the dreaded:

A previous FILESTREAM configuration attempt was incomplete.
FILESTREAM may be in a an inconsistent state until
re-configured.

Huh. How do I reconfigure it?

I've read everything on the first ten pages of Google re
streaming and filetables.

Any ideas?