SQL Attachability checks fail with the next error if FILESTREAM is disabled:
Attachability check failed for SQL database PullDown of instance <DB-NAME>:
•Failed Operation Exception: Attach database failed for Server ‘<DB-NAME>\APPASSURE,51177′.
?Execution Failure Exception: An exception occurred while executing a Transact-SQL statement or batch.
?Sql Exception: FILESTREAM feature is disabled.
A file activation error occurred. The physical file name ‘C:\ProgramData\AppRecovery\MountPoints\a056d93a-922c-4fc3-8074-8fb3bdcae798\F_\<DB-NAME>\MSSQLData\PullDown_filestream’ may be incorrect. Diagnose and correct additional errors, and retry the operation.
Could not open new database ‘AA-PullDown-b85f53bd-f075-4ced-ab20-4fbfad051fd7′. CREATE DATABASE is aborted.
This issue occurs when performing a SQL Attachability check on a FILESTREAM database, and the local SQL instance installed on the Rapid Recovery core does not have the FILESTREAM feature enabled.
On the Start menu, navigate to All Programs > SQL Server > Configuration Tools, and then select SQL Server Configuration Manager.
In the list of services, right-click SQL Server Services, and then select Open.
In the SQL Server Configuration Manager snap-in, locate the instance of SQL Server on which you want to enable FILESTREAM.
Right-click the instance, and then select Properties.
In the SQL Server Properties dialog box, select the FILESTREAM tab.
Select the Enable FILESTREAM for Transact-SQL access check box.
Select Apply.
In SQL Server Management Studio, select New Query to display the Query Editor.
In Query Editor, enter the following Transact-SQL code:
EXEC sp_configure filestream_access_level, 2;
RECONFIGURE;
Select Execute.
Restart the SQL Server service.
See this Microsoft KB for more information: http://msdn.microsoft.com/en-us/library/cc645923.aspx
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 使用条款 隐私 Cookie Preference Center