Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dineshrajan_it
Posting Yak Master
217 Posts |
 Posted - 2008-09-08 : 08:56:35
|
| Hi,iam new to Filegroups concept. i have two files inside a Filegroup "FileGroup1". i have moved a table to FileGroup1. now i want to remove that filegroup1. so first i did shrink the first file "File1" from filegroup1. then i removed that File1. Next i tried to shrink the File2. but i get an error message stating that "There is insufficient space in the filegroup to complete the emptyfile operation."Please help me out |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-09-08 : 11:33:23
|
| Are there any tables in FileGroup1? If so, then you have to either drop, or move them, before you can remove the last file. |
 |
|
|
|
|
|
FileGroups