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.
Vyas, MVP (SQL Server)
What hardware is your SQL Server running on?
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