February 26, 2012 at 7:58 pm
Hi,
I am looking for some information and steps required to enable File Stream feature in Existing database and server.
What is the step which i need to configure??
What are security steps i need to configure??
What is disadvantage and problem we can face with this feature??
Thanks in advance for your help.
February 27, 2012 at 1:24 am
to enable file stream, you need to first logon to the server and open up SQL Server Configuration Manager.
in the SQL Server Services section, right click the SQL Server (MSSQL.......) service and do properties
on the FILESTREAM tab select the options you need then click ok,
then use SSMS to connect to the server, right click the server and do properties --> Advanced, then change Filestream Access Level to the level you need.
Restart SQL and your done.
This URL might help with the disadvantages http://lennilobel.wordpress.com/2010/11/18/sql-server-2008-filestream-part-1-of-3-introducing-filestream-2/
February 27, 2012 at 1:26 am
Paul Randal wrote a technical article that is worth reading, showing the various ways to enable it and the performance issues (and other areas too):
http://msdn.microsoft.com/en-us/library/cc949109(v=sql.100).aspx
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply