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 |
|
aiken
Aged Yak Warrior
525 Posts |
 Posted - 2003-03-18 : 22:52:08
|
I've had this outstanding issue for a while, and just can't seem to beat it. You can read my previous post (from November) here: http://sqlteam.com/Forums/topic.asp?TOPIC_ID=21130My primary filegroup has two files in it. I want to delete one of those files, but I just *cannot* get it to go away. dbcc shrinkfile with the EMPTYFILE option, you name it.Any further ideas at this point? I'm transferring the DB to a new server and really want to clean things up. I'd hate to have to transfer this crappy little file and clutter up my nice file namespace design  Thanks-b |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2003-03-19 : 02:11:00
|
quote:
I've had this outstanding issue for a while, and just can't seem to beat it. You can read my previous post (from November) here: http://sqlteam.com/Forums/topic.asp?TOPIC_ID=21130My primary filegroup has two files in it. I want to delete one of those files, but I just *cannot* get it to go away. dbcc shrinkfile with the EMPTYFILE option, you name it.Any further ideas at this point? I'm transferring the DB to a new server and really want to clean things up. I'd hate to have to transfer this crappy little file and clutter up my nice file namespace design Thanks-b
hi,You can shrink a file using the shrink files tab in the EM after migrating the data from the file into some other file then use alter database to remove the file from the filegroup.regards,Harshal.Expect the UnExpected |
 |
|
|
aiken
Aged Yak Warrior
525 Posts |
Posted - 2003-03-19 : 17:31:17
|
| Unfortunately, that's exactly what's not working for me. I can shrink it to my heart's content, but it always says "file is not empty" when I try to remove it. And then, even with the EMPTYFILE option used on the shrink, it starts filling up again.Cheers-b |
|
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2003-03-20 : 04:35:48
|
quote:
Unfortunately, that's exactly what's not working for me. I can shrink it to my heart's content, but it always says "file is not empty" when I try to remove it. And then, even with the EMPTYFILE option used on the shrink, it starts filling up again.Cheers-b
is u'r database continuously inuse?Expect the UnExpected |
|
|
|
aiken
Aged Yak Warrior
525 Posts |
Posted - 2003-03-20 : 13:52:30
|
| Yes -- I will have some downtime when we do the server move, I suppose, but I was hoping to take care of this before then.Cheers-b |
|
|
|
|
|
|
|
|
Remove file from filegroup?