Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Join Separate MDF Files Into One
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Divers
Thread ID:
00810156
Message ID:
00810447
Vues:
15
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform