automate local copy of SQL DB

you cannot set up scheduled job on our sql server.

my recommendation

- set up a DTS package on your local computer to download the whole DB to your server

- schedule it to fit your need.

hope this helps

quote:Originally posted by yzarc

I would like to automate downloading a copy of my SQL database.
I would like for it to occur nightly and then once a week I will archive the data onto CD.

I figure I will have to use dts at some point and then after sufficient time for dts to complete then run a local backup.

I have a version of SQL running on my local computer.

Thanks,
Greg

Greg Kelley
</blockquote id="quote"></font id="quote">