I'm hosting a mission critical Database on a remote SQL 7 NT system.
What is the best method to backup the database (or import the information)
daily
to our local computer (sql 2000)?

I tried to use DTS package scheduly, but this works only for 1 table.
I need a DIFFRENT table for each day, with a unique name:

something like: backupdb041201 -> (db backup as for 04/12/2001)

Any solutions?

Thanks alot!!

-=Michael.