Copy from server to server

Microsoft SQL Server

I work with sqlServer Y2K and I want to create a programme to copy a full
database from a server to and other.
I want to write a programme to do so.
So is it possible to make this copy with SQL DMO or SQL Transac ?
Is there a function like "copy database (src,destination)" .????

Thanks for Help
Christophe.
You could use BACKUP and RESTORE commands to backup a database on one server
and restore it onto another.

You could also use Copy Database Wizard.

See SQL Server Books Online for more information.

--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm




I work with sqlServer Y2K and I want to create a programme to copy a full
database from a server to and other.
I want to write a programme to do so.
So is it possible to make this copy with SQL DMO or SQL Transac ?
Is there a function like "copy database (src,destination)" .????

Thanks for Help
Christophe.