Showing posts with label ithere. Show all posts
Showing posts with label ithere. Show all posts

Wednesday, March 21, 2012

files, filegroups

Can someone tell me if we can move files to different filegroups in SQL2K5? If we can, how do you do it?

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