Copy from server to 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
Regards
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
"meynet" <meynet@.csprogramme.com> wrote in message
news:bkbl5s$s6e$1@.news-reader1.wanadoo.fr...
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
Regards
Christophe.|||I have already tried it.
The problem is that you must have (2*size of database)Mdb free on your
machine !
1 size for backup
1 size for database to restore...
Is there no other way ?
Thanks
Christophe
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> a écrit dans le message de
news:uvQ5TPbfDHA.3324@.TK2MSFTNGP11.phx.gbl...
> 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
>
>
> "meynet" <meynet@.csprogramme.com> wrote in message
> news:bkbl5s$s6e$1@.news-reader1.wanadoo.fr...
> 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
> Regards
> Christophe.
>
>|||Great ! I will have a look à this DTS sample !
Thanks a lot
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> a écrit
dans le message de news:O7qD9SbfDHA.3104@.TK2MSFTNGP11.phx.gbl...
> There are many possibilities. You can use Backup and Resttore T-SQL
> commands. ou can use sp_detach_db, copy the files and sp_attach_db
> procedure. You can use DTS object model - there is even a sample app
called
> DTSCopyDatabase included in examples that can be installed from the SQL
> Server CD.
> --
> Dejan Sarka, SQL Server MVP
> FAQ from Neil & others at: http://www.sqlserverfaq.com
> Please reply only to the newsgroups.
> PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
> "meynet" <meynet@.csprogramme.com> wrote in message
> news:bkbl5s$s6e$1@.news-reader1.wanadoo.fr...
> > 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
> > Regards
> >
> > Christophe.
> >
> >
>