Monday, February 20, 2012

Move data from NDF file to MDF file

I have a database which has two data files, MDF and NDF.
The question is how can I move data in NDF into MDF file,
so I could delete the NDF file from the database.
Thanks
ALexHi,
I HAVE ALREADY REPLIED TO UR OLD POST.
EMPTY FILE:
Migrates all data from the specified file to other files . This option
allows the file to be dropped using the ALTER DATABASE statement.
THANKS
HARI
MCDBA
"Alex" <anonymous@.discussions.microsoft.com> wrote in message
news:19f9901c41d5a$bdfea1a0$a501280a@.phx
.gbl...
> I have a database which has two data files, MDF and NDF.
> The question is how can I move data in NDF into MDF file,
> so I could delete the NDF file from the database.
> Thanks
> ALex

No comments:

Post a Comment