I'm trying to backup a database, which has been created by someone I don't have access to. I get this error message:
The backup of the file or filegroup "fileStream" is not permitted, because it is not online.
and then it suggests to backup database via T-SQL to only backup online filegroups. However, this is not my requirement.
I want to bring the offline filegroup online again. I saw this answer which suggests using
alter database command to take a fielgroup offline.
alter database dn_name modify file (name='filegroup_name', offline) go
However, as I saw the documentation of the mentioned command, there is no option to bring a fielgroup online back. What should I do? How can I bring a filegroup (or a file) back online in SQL Server 2012?