Earlier quoted context omitted.
I think that is one of the main reason it failed to launch. It was just too easy for the metadata stored in the separate database to become out of sync with the actual file data. Microsoft saw the tech support nightmare this could generate, and abandoned the project.
It was abandoned due to The Cloud. There was no need for WinFS as a tech when you could store everything in The Cloud. It was also complex, ran poorly, and would have required developers to integrate their applications. Microsoft had long solved the problem of blobs and metadata in ESE and SharePoint's use of MS SQL for binary + metadata storage.
I mean, for some definitions of “just”, “SQL database”, and “arbitrary data.” :) It was a schematised graph database implemented on top of a slimmed-down version of SQL Server. The query language was not SQL-based.
> It was abandoned due to The Cloud.
It was discontinued circa 2007. The cloud was much less of a Thing back then. I don’t recall that factoring at all into the decision to cancel the project, though it would have been prescient.
(Disclaimer: I was on the WinFS team at Microsoft.)