copy a database from one SQL server to another.

Hello:
I'm new in the SQL server world. But I need to copy one SQL database
on machineA to machineB. By looking at the tool bar, I think export
will do the job for me, is anybody can provide the detail info? DO I
need to create an empty database on MachineB first, any documentation
repository I can read and learn?
Thank you so much!
Sincerely,
QGThree different approaches can be found in the following links:

http://support.microsoft.com/defaul...b;en-us;Q304692
http://support.microsoft.com/defaul...B;en-us;q224071
http://support.microsoft.com/defaul...b;en-us;Q274463

--
- Anith
( Please reply to newsgroups only )|||Hi

To add my favourite link!

http://support.microsoft.com/defaul...b;en-us;Q314546

John

"Grace Gu" <qing.gu@.engelhard.com> wrote in message
news:147725ae.0307071218.7b361934@.posting.google.c om...
> Hello:
> I'm new in the SQL server world. But I need to copy one SQL database
> on machineA to machineB. By looking at the tool bar, I think export
> will do the job for me, is anybody can provide the detail info? DO I
> need to create an empty database on MachineB first, any documentation
> repository I can read and learn?
> Thank you so much!
> Sincerely,
> QG