KB3042629 - FIX: Error 33415 occurs when you restart the SQL Server service or alter database in SQL Server 2012 or SQL Server 2014

Applies to: SQL Server 2012 DeveloperSQL Server 2012 EnterpriseSQL Server 2012 Standard


Assume that you create a snapshot on a database that contains FILESTREAM filegroups in Microsoft SQL Server 2012 or SQL Server 2014, and FILESTREAM non-transactional access is enabled on the database. After you restart the SQL Server service, non-transactional access is disabled on the database. Additionally, you receive the following error message 33415 in the error log:
FILESTREAM DIRECTORY_NAME '<directory_name>' attempting to be set on database '<database_name>' is not unique in this SQL Server instance. Provide a unique value for the database option FILESTREAM DIRECTORY_NAME to enable non-transacted access.
When you try to alter the database, you also receive the error message 33415, and the database is not altered.


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.