our SQL administrator recently left and after his departure we need to set-up
a procedure to copy a database from one SQL2K server to another SQL2K server
on a daily or weekly basis. there does not need to be any other
synchronization. would this be best accomplished by setting-up a DTS
package, putting in the login credentials, and then setting up a time
interval for the copy procedure ? or is the DTS packages only for a
one-time copy and scheduled copies are best done another way ? TIA ...

figured it out - just a simple DTS package seemed to take care of everything.


"E-Double" wrote:

A weekly copy hmmmm

I would probably use BACKUP and RESTORE. very simple and very clean.
You could use DTS
You could also use snapshot replication.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"E-Double" <EDouble (AT) discussions (DOT) microsoft.com> wrote