O'Reilly logo

Microsoft® SQL Server 2008 R2 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Enabling FILESTREAM Storage

If you decide to use FILESTREAM storage, it first needs to be enabled at both the Windows level as well as at the SQL Server Instance level. FILESTREAM storage can be enabled automatically during SQL Server installation or manually after installation.

If you are enabling FILESTREAM during SQL Server installation, you need to provide the Windows share location where the FILESTREAM data will be stored. You can also choose whether to allow remote clients to access the FILESTREAM data. For more information on how to enable FILESTREAM storage during installation, see Chapter 8, “Installing SQL Server 2008.”

If you did not enable the FILESTREAM option during installation, you can enable it for a running instance of SQL ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required