I have a database that I'll be moving to a new machine. The existing setup
has the data in 3 separate mdf files. The new machine has more than enough
space to accommodate the 3 files in the same location, as well as enough
room
to grow for the foreseeable future.
I've done a test load of the existing data onto the new server from the .bak
dump file. Since the data was in 3 files I had to restore it into 3 files. I
was wondering if it's possible (and how I would go about it) to join the
separate mdfs into one large one.
Thanks in advance for any replies.
Ricknever done this but I think you can do this with ALTER DATABASE. Check it
out in BOL or http://support.microsoft.com/?kbid=814576
"Rick" <reddinger@.serif.com> wrote in message
news:%237o9PqbFEHA.624@.TK2MSFTNGP10.phx.gbl...
> Hi all,
> I have a database that I'll be moving to a new machine. The existing setup
> has the data in 3 separate mdf files. The new machine has more than enough
> space to accommodate the 3 files in the same location, as well as enough
> room
> to grow for the foreseeable future.
> I've done a test load of the existing data onto the new server from the
.bak
> dump file. Since the data was in 3 files I had to restore it into 3 files.
I
> was wondering if it's possible (and how I would go about it) to join the
> separate mdfs into one large one.
> Thanks in advance for any replies.
> Rick
>
>|||Thanks, that worked. Come to realize you can also do this through the GUI in
the "Shrink files" dialog, saves some typing
Thanks again.
"ME" <mail@.moon.net> wrote in message
news:OHpXEAcFEHA.2408@.TK2MSFTNGP10.phx.gbl...
> never done this but I think you can do this with ALTER DATABASE. Check it
> out in BOL or http://support.microsoft.com/?kbid=814576
> "Rick" <reddinger@.serif.com> wrote in message
> news:%237o9PqbFEHA.624@.TK2MSFTNGP10.phx.gbl...
setup
enough
> .bak
files.
> I
the
>
