Here is the deal, I HOPE someone can assist me in this. I have a SQL server database that is hosted through a company that wont allow me any replication or subscription services to sync my data to a local SQL server I have running. I have been attempting to come up with something on my own in order to at least have my remote data sync to my local copy in various intervals throughout the day. Here is what I have come up with so far but am looking for a better and more efficient way to do this. (And this isn't 100% functional at this point either):

BACKUP LOG DBname TO backup_device_name WITH INIT, NO_TRUNCATE

WAITFOR DELAY '00:00:05'

(this next step executes a stored procedure on the destination server that looks like this):

restore_Tiamat_ETS_log_backups AS

ALTER DATABASE Tiamat_ETS SET SINGLE_USER

RESTORE LOG Tiamat_ETS
FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\logs\Tiamat_ETS_log_backup_dev ice.bak'
WITH
DBO_ONLY,
STANDBY = 'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\logs\undo_Tiamat_ETS.ldf'

WAITFOR DELAY '00:00:05'
GO

That is how far I am now but it isn't working how I would like. Any thoughts?

what about it isn't working the way you like?

Can you get a connection to the remote DB and run a DTS?