This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 40%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
How to offline the whole filegroups that has multiple files ?
ALTER DATABASE dbname MODIFY FILE (NAME = 'filename', OFFLINE) << this can only offline a single file
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 78%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECZ%3C/text%3E%3C/svg%3E)
Hi @sakuraime ,
Is there any update on this case?
If the answer is helpful, please click "Accept Answer" and upvote it.
Hi @sakuraime ,
Please read the MS doc :ALTER DATABASE (Transact-SQL) File and Filegroup Options. You can MODIFY FILE to OFFLINE, but there is no command to make a filegroup offline.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 30%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETH%3C/text%3E%3C/svg%3E)
Please don't post where there nothing more to add. Erland already replied with the same information.
Yes, but Books Online says: Sets the file offline and makes all objects in the filegroup inaccessible.
Furthermore: Use this option only when the file is corrupted and can be restored. A file set to OFFLINE can only be set online by restoring the file from backup.
Just a note that you can set the filegroup Read Only. You don't tell what your scenario is, so it is difficult to suggest what might be useful for you.