I am getting the SQL Server Error 5520 when i try to add a FILSTREAM file into a filegroup. I am trying to add multiple files to a FILESTREAM filegroup.
Error Message is:
"FILESTREAM file 'MyFileStream' cannot be added because its destination filegroup cannot have more than one file."

sathish B R (brs.sathish (AT) gmail (DOT) com) writes:
Isn't that message rather self-explanatory?

The "file" in case of a FILESTREAM file group is a folder, which may
include a number of files.

What do you want to achieve?

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx