Here is an excerpt from BOL.
REMOVE FILEGROUP filegroup_name
Removes a filegroup from the database. The filegroup cannot be removed unless it is empty. Remove all files from the filegroup first by either ***moving the files to another filegroup*** or, if the files are empty, by removing the files.
Is that a typo or what?
Thanks.I am hoping Microsoft folks will reply to this. Please let me know if the BOL has an error or you can actually move files among filegroups.
|||
This is a doc error. We can not move files between filegroups.
I've reported the problem to our doc team.
Thanks for reporting it here.
sql