Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Join Separate MDF Files Into One
Message
From
15/07/2003 17:35:31
 
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
00810156
Message ID:
00810447
Views:
14
>Is there a way to reassign a FileGroup to a File?

I don't know of anything. Have you tried Google?

OK. you can manually move the data by recreating the clustered index on the other filegroup. For the non-clustered indexes, you'll have to drop and recreate them.

-Mike

>Hi!,
>Thanks for the reply,
>
>The two files I have belongs to different FileGroups, and the DBCC SHRINKFILY with EMPTYFILE option works only for files on the same FileGroup.
>
>Is there a way to reassign a FileGroup to a File?
>
>
>Thanks again in advance!.
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Reply
Map
View

Click here to load this message in the networking platform