Created
April 24, 2016 16:00
-
-
Save niisar/6b76625d18eec5d4e26d022d2082c7b3 to your computer and use it in GitHub Desktop.
Add a FILESTREAM filegroup to the database
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Add a FILESTREAM filegroup to the database | |
ALTER DATABASE PhotoLibrary | |
ADD FILEGROUP FileStreamGroup1 CONTAINS FILESTREAM | |
-- Add a container to the FILESTREAM filegroup | |
ALTER DATABASE PhotoLibrary | |
ADD FILE | |
(NAME = PhotoLibrary_blobs, | |
FILENAME = 'C:\Demo\PhotoLibrary\Photos') | |
TO FILEGROUP FileStreamGroup1 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment