May 19, 2008 11:25 AM|rjcox|LINK
Do you want two way (i.e. changes to your local database will also appear in the hosted one) or one way (you have a local copy, but any changes you make will not be copied back to the hosted database)?
SQL Server supports replication, which might be the answer (solves the general problem). Depending on what dsata is changing, something build with SSIS (neé DTS) could do it.
Or, if you only need to refresh so often, copy a backup and restore locally (likely the simplest).