DTS help please

Hi,
I am using a DTS package to "Export Data" between two databases, but in fact
I want to be able to create a copy of the first db.. I am obviously a
newbie, but is there a better way to create a duplicate or "mirror" of the
main database and use a DTS package to automate the process?
thank you again
G
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.805 / Virus Database: 547 - Release Date: 03-Dec-04Hi
A quicker way would be to use BACKUP/RESTORE. It would depend on how often
you wish to make the copy and how up-to-date it needs to be. You could also
check out Log Shipping and Replication.
http://support.microsoft.com/defaul...en-us;Q314546#2
http://support.microsoft.com/kb/304692/EN-US/
http://msdn.microsoft.com/SQL/sqlwa...on/default.aspx
http://msdn.microsoft.com/library/d...LServer2000.asp
John
"Neither rhyme nor reason" <sportman_6663@.yahoo.ca> wrote in message
news:fnuae.27483$Jg5.1397312@.news20.bellglobal.com...
> Hi,
> I am using a DTS package to "Export Data" between two databases, but in
> fact
> I want to be able to create a copy of the first db.. I am obviously a
> newbie, but is there a better way to create a duplicate or "mirror" of the
> main database and use a DTS package to automate the process?
>
> thank you again
> G
>
> --
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.805 / Virus Database: 547 - Release Date: 03-Dec-04
>