How to presize filestream data file?

Question

How to presize filestream data file?

Mani-584606

SSChampion

Points: 11788
More actions
September 9, 2011 at 11:43 am

#247775

Is there way we can pre size filestream drive?
Or it's going to be a just a file and we do not need to do anything on presizing the file as we do for data & log files?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

No pre-sizing. SQL creates and manages those files, you should not touch them in any way.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Mani-584606 SSChampion Points: 11788 More actions · Answer 2

Thanks Gail,

I do have one more question and I hope you can clarify that.

I have configured FileStream as below.

Use Mydb
go
if not exists (select groupname from sysfilegroups where groupname=N'RBSFileStream')
Alter database Mydb
add filegroup RBSFileStream contains filestream
Alter database Mydb
add file (name = RBSFilestream_Mydb, filename = 'D:\RBSFileStream\Mydb') to filegroup RBSFilestream

Question:

1. Can we add multiple Filegroups for Filestream?

2. Can we add multiple files inside Filestream filegroup?

Thanks

Mani-584606 SSChampion Points: 11788 More actions · Answer 3

I went through the below link and I'm clear that FileStream cannot have Multiple Files in a FileStream Filegroup.

But, I'm not sure whether we can have Multiple Filegroups for Filestream? Please advice...

http://msdn.microsoft.com/en-us/library/bb522469.aspx

Thanks