Solved the problem of "filestream function disabled" When sqlserver restored data.

Solved the problem of "filestream function disabled" When sqlserver restored data.

Due to test requirements, I downloaded the Bak file of the adventureworks2008 instance database on the Internet. During restoration, the following error occurs: "filestream function disabled", as shown in:

When the above problem occurs, we usually use the sqlserver Configuration Manager to set the sqlserver instance service and restart the sqlserver instance service, as shown in:

Generally, you can restore the database by setting the preceding settings. However, when restoring the adventureworks2008 database, you still cannot restore the database by setting the preceding settings. If the error persists, you have to find other reliable methods, view the msdn help file and find out that it is caused by the access level of sqlserver. If it cannot be manually executed, run the following command to restore it successfully.

USE masterGOEXEC sp_configure filestream_access_level, 2RECONFIGURE 

Attach the file again.

　　

 

Note:

You can use the filestream_access_level option to change the filestream access level of the SQL server instance.

Note:
You must enable the Windows filestream management settings before this option takes effect. You can enable these settings when installing SQL Server or use the SQL Server Configuration Manager.

 

Value	Definition
0	Disable filestream support for this instance.
1	Enable filestream for Transact-SQL access.
2	Enable filestream for Transact-SQL and Win32 stream access.

　　

Here, we only make a record to help people who encounter the same problem with less detours.

Welcome to the database discussion group (multiple DBA teams), group number:190401986(Note: invite you to the blog site)

 

Author: erichu Source: http://blog.csdn.net/chinahuyongemail: 406590790@qq.comQQ exchange: 406590790 QQ group: 16653241 platform blog: [csdn] http://blog.csdn.net/chinahuyong [cnblogs] Networks. Focused on Microsoft platform project architecture, management, and enterprise solutions, with many years of project development and management experience, he has organized and developed multiple large projects for many times and is proficient in DOTNET, dB (sqlserver, Oracle, etc.) technology. Familiar with Java, delhpi, and Linux operating systems, with solid network knowledge. Have certain accomplishments in the field of object-oriented, service-oriented, and database. He is currently engaged in DB management and development, winform, WCF, WebService, web page data capturing, ASP. NET and other project management, development, architecture, and other work. If you have any questions or suggestions, please kindly advise me! The copyright of this article is shared by the author and the csdn blog. You are welcome to repost it. However, you must keep this statement without the author's consent and provide the original article connection clearly on the article page. If any problem occurs, you can contact me via email or QQ. Thank you very much.