I hope someone can help. I have a SQL 2000 database that is hosted through a company which allows minimal management due to security reasons. This database is where all of my data from multiple domains is being managed. I have SQL Server 2000 also running locally and I want to synchronize my local machine with the remote as best I can. I am told that I can use DTS in order to import/export the remote into my local server. My questions and concerns are this:

1) - first off, what is the best way to set this up so that any table changes/additions are copied locally if need be. There were updates occurring on the hosted tables often so I want the local copies to be updated with records and changes just the same.

2) - How can I set this up to occur peridoically when I desire - say, 3 or 4 times per day.

I have not had to manage a remote database like this before so I want to ensure I am doing it correctly. If even a few times a day my local machine can automatically be updated with the current remote data and definitions that would be great.

I apprecaite any help in advance - thanks.

You may have several options depending on the size of your database and connections speed.

1. You can try log shipping
2. You can try also schedule a job that will
   A. backup your remote database to your local machine
   B. Restore the backup to your local Machine


Jaime E. Maccou