SQL Attachability check fails for some agents showing the following error:
The attachability check has failed for the SQL database 'DB_NAME' of instance 'MSSQLSERVER' because the FileStream path 'C:\ProgramData\AppRecovery\MountPoints\250f2630-1d54-4bb4-8426-7bafac2c6fd2\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\XCGVisionPRODFILES_FS' not supported by SQL Server. The path too long. Maximum length is '160' symbols.
To Force the Attachability Check from the Core Console follow these steps:
Quest Software does not provide support for problems that arise from improper modification of the registry. The Windows registry contains information critical to your computer and applications. Make sure you back up the registry before modifying it. For more information on the Windows Registry Editor and how to back up and restore it, refer to Microsoft Article ID 256986 “Description of the Microsoft Windows registry” at Microsoft Support.