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?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
Here's how it works:
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
migrated from stackoverflow.com Apr 18 '12 at 13:42
This question came from our site for professional and enthusiast programmers.
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.