.Bak or .mdf..What's the best way to move DB on another Server

Hi all
I can copy my .BAK on my new server and then restore the Database, or
copy my .mdf and .ldf and then reattach my Database...but what is the
best method.
What can I do for my DTS.
Please give me some answers!!!
ThanksI'd prefer copy .bak files and then perfom restore command.
"Guy Tanguay" <guy_tanguay@.hotmail.com> wrote in message
news:3b53412a.0309090505.643c61bc@.posting.google.com...
> Hi all
> I can copy my .BAK on my new server and then restore the Database, or
> copy my .mdf and .ldf and then reattach my Database...but what is the
> best method.
> What can I do for my DTS.
> Please give me some answers!!!
> Thanks|||I agree with Uri, since the bak files are smaller. You can always move the
mdf file with its logs files and attach them as well.
For your DTS packages you can open them and perform a SAVE AS command on the
File Menu to the new Server. For your jobs you can script them out.
Yovan Fernandez
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23jHIjOtdDHA.2640@.TK2MSFTNGP09.phx.gbl...
> I'd prefer copy .bak files and then perfom restore command.
>
> "Guy Tanguay" <guy_tanguay@.hotmail.com> wrote in message
> news:3b53412a.0309090505.643c61bc@.posting.google.com...
> > Hi all
> >
> > I can copy my .BAK on my new server and then restore the Database, or
> > copy my .mdf and .ldf and then reattach my Database...but what is the
> > best method.
> >
> > What can I do for my DTS.
> >
> > Please give me some answers!!!
> > Thanks
>|||Thank U everybody
Long Life to SQL Server