2

Our production DB is using the FILESTREAM option for our sharepoint environment. The volume where the files are residing is getting full and I am planning to add another volume to ease space issues. Is the solution as simple as creating another filestream container and adding this container on the existing filestream filegroup? Would SQLServer take care of balancing among the two volumes?

2

Unfortunately no, not in SQL Server 2008.

According to FILESTREAM Overview - multiple containers can be added to a single FILESTREAM Filegroup but only as of SQL 2012.

1
  • 1
    You're welcome. The best way to show your appreciation/love is by giving up votes/marking it as the answer. – John Sansom Apr 19 '12 at 19:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.