SQL 2012 Restore Problem
-
I'm trying to restore a DB from backup. I get the following error "System.Data.SqlClient.SqlError: FILESTREAM feature is disabled." I have tried to enable FileStream by following This[^] When I get to the Config Manager and open the Properties and check the checkboxes I get "There was an unknown error applying the FILESTREAM settings. Check the parameters are valid." Of course this doesn't tell me anything useful. Anyone have any ideas? Thanks
If it's not broken, fix it until it is. Everything makes sense in someone's mind. Ya can't fix stupid.
-
I'm trying to restore a DB from backup. I get the following error "System.Data.SqlClient.SqlError: FILESTREAM feature is disabled." I have tried to enable FileStream by following This[^] When I get to the Config Manager and open the Properties and check the checkboxes I get "There was an unknown error applying the FILESTREAM settings. Check the parameters are valid." Of course this doesn't tell me anything useful. Anyone have any ideas? Thanks
If it's not broken, fix it until it is. Everything makes sense in someone's mind. Ya can't fix stupid.
Try using option 2, to see if TSQL gives you a better error message:
USE master
GO
EXEC sp_configure 'show advanced options'
GO
EXEC sp_configure filestream_access_level, 1
GO
RECONFIGURE WITH OVERRIDE
GOIf it doesn't, then check the SQL Server logs and the Windows event logs to see if there's any useful information there.
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
-
Try using option 2, to see if TSQL gives you a better error message:
USE master
GO
EXEC sp_configure 'show advanced options'
GO
EXEC sp_configure filestream_access_level, 1
GO
RECONFIGURE WITH OVERRIDE
GOIf it doesn't, then check the SQL Server logs and the Windows event logs to see if there's any useful information there.
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
Already tried that. It says it worked but it really didn't. I ended up installing another instance and setting FileStream enabled during the install.
If it's not broken, fix it until it is. Everything makes sense in someone's mind. Ya can't fix stupid.
