copying a DB from one SQL Server to another SQL server which are not in the sam

Hello All,
I am new to SQL Server.

I want to copy a Database from my SQL server to another SQL server ,which are not connected in same LAN. The destination SQL server also has the same DB ,Table structures.

Can you suggest me any idea of doing this.

I would appriciate your fastest suggestion.

Thanks!!.Backup Database
Copy
Paste
Restore Database|||Originally posted by Enigma
Backup Database
Copy
Paste
Restore Database

Hi Enigma,
Thanks for your reply.

If I am not wrong ,the DBBackup will copy all the Tables in the DB.

Is it possible to take a backup of few tables from a DB.(This is what needed, sorry for not giving full information on my first question).|||Yup
1st server... script tables ... bcp out ...

2nd server ... run script ... bcp in|||Originally posted by Enigma
Yup
1st server... script tables ... bcp out ...

2nd server ... run script ... bcp in

Hi,
Please give some Examples using VB for the above.
thanx in advance. Looking forward for your reply.

Premnath