August 23, 2011 at 3:27 pm
Hi,
I need to setup filestream for 3 Share point content databases
I have performed the below for FILESTREAM setup:
1.enabled Filestream from SQL Server configuration manager
2.Executed the below command
EXEC sp_configure FILESTREAM_access_level, 2
RECONFIGURE WITH OVERRIDE
GO
3.created MasterKey and backedup the masterkey
4. And performed the below for each database and it created 3 folders (Mydb1, Mydb2, Mydb3) inside the folder RBSFileStream and each folder has $FSLOG & filestream.hdr file.
Use Mydb1
go
if not exists (select groupname from sysfilegroups where groupname=N'RBSFileStream')
Alter database Mydb1
add filegroup RBSFileStream contains filestream
Alter database Mydb1
add file (name = RBSFilestream_Mydb1, filename = 'D:\RBSFileStream\Mydb1') to filegroup RBSFilestream
Use Mydb2
go
if not exists (select groupname from sysfilegroups where groupname=N'RBSFileStream')
Alter database Mydb2
add filegroup RBSFileStream contains filestream
Alter database Mydb2
add file (name = RBSFilestream_Mydb2, filename = 'D:\RBSFileStream\Mydb2') to filegroup RBSFilestream
Use Mydb3
go
if not exists (select groupname from sysfilegroups where groupname=N'RBSFileStream')
Alter database Mydb3
add filegroup RBSFileStream contains filestream
Alter database Mydb3
add file (name = RBSFilestream_Mydb3, filename = 'D:\RBSFileStream\Mydb3') to filegroup RBSFilestream
Questions:
1. In above, which one is the FILESTREAM DATA CONTAINER?
2. Which one is FILESTREAM FILEGROUP?
3. What is meant by FILESTREAM data containers can be nested (I know the answer is NO, data containers cannot be nested. can you explain the same based on above?)
4. I uploaded Blob objects for Mydb1 and then two new folders with GUID got created under the folder RBSFileStream (along with $FSLOG, Filestream ). Insdide those 2 new GUID folders, therse is one more GUID folder and inside that, I can see the actula files
Is there any known folder structure for FILESTREAM?
Thanks
August 24, 2011 at 11:44 am
I went through the link http://technet.microsoft.com/en-us/library/bb933993.aspx
which says "A FILESTREAM filegroup is a special filegroup that contains file system directories instead of the files themselves. These file system directories are called data containers"
So in below script, which one is called Filestream Container?
1. D:\RBSFileStream or
2. D:\RBSFileStream\Mydb1
Use Mydb1
go
if not exists (select groupname from sysfilegroups where groupname=N'RBSFileStream')
Alter database Mydb1
add filegroup RBSFileStream contains filestream
Alter database Mydb1
add file (name = RBSFilestream_Mydb1, filename = 'D:\RBSFileStream\Mydb1') to filegroup RBSFilestream
Thanks
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply