August 18, 2011 at 9:39 pm
Hi,
I'm implementing Filestream RBS for a share point content database as below.
use [WSS_Content]
if not exists
(select groupname from sysfilegroups
where groupname=N'RBSFilestreamProvider')
alter database [WSS_Content]
add filegroup RBSFilestreamProvider contains filestream
use [WSS_Content]
alter database [WSS_Content]
add file (name = RBSFilestreamFile, filename =
'c:\Blobstore')
to filegroup RBSFilestreamProvider
Question:
After creating filestream filegroup and filestream file, I want to pre size the file to 100 GB. How to do that?
and how to decrease/increase it's size?
I'm trying to do this from SSMS but there is no option for that (Please see the attachment)
thanx
August 19, 2011 at 7:44 am
I'm pretty sure that FILESTREAM stores individual files, not a single file like a database file. Each time you write a file out to the FILESTREAM, it gets stored out there. The FILESTREAM then ensures that the file can't be deleted until the row that refers to that file is deleted, maintaining referential integrity.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply