Enable File Stream on SQL Server 2008
Enable File Stream on SQL Server
2008
By : Kasim Wirama, MCDBA, MCITP
SQL Server 2008 has filestream
feature. It marries best world power of file management by windows file system
and database transaction atomicity. If you have LOB files such as documents,
images, big size file audio/video, filestream options offers best performance
and ease of administration. If you haven’t enabled filestream feature during installation,
you are still able to enable it during post installation.
Here is steps how to enable file
stream :
1. Open
SQL Server Configuration Manager (Start > Programs > Microsoft SQL Server
2008 > Configuration Tools > SQL Server Configuration Manager).
Note : SQL
Server Configuration Manager is the replacement of SQL Server Control Manager
of SQL Server 2000.
2. Go
to SQL Server Services node, and select SQL Server instance that you want to
enable filestream feature.
3. Double
click on the SQL Server instance, it display SQL Server <instance>
Properties dialog box. By default if you have only one instance, the value is
MSSQLSERVER. But in my computer, I enable it for delta\SQL2008_1 named
instance.
4. Click
FILESTREAM tab, and select checkboxes to enable FILESTREAM, enter share name
for files.
Now your SQL Server has
filestream-enabled feature. J