add a file group with FILESTREAM support to a database

Professionaluser
Posted by Professionaluser under Sql Server category on | Points: 40 | Views : 684
use below code to add a file group to a database with FILESTREAM option/support,

ALTER DATABASE [TestDatabase] ADD FILEGROUP TestDatabase_FSGroup CONTAINS FILESTREAM
GO


You will face 'FILESTREAM is not enabled' error until you enable FILESTREAM support on SQL server instance

Comments or Responses

Login to post response