Pseudo-Data Warehousing

[DCSS]

I am trying to have computer B (a data warehouse machine) replicate computer A (main server with 2x10GB databases), but these databases are live computer, so I can't actually replicate them, since it is already replicating to 2 other machines.So what is the best way to automatically replicate databases in SQL Server.I have tried and object transfer (fully automated, but takes about 8 hours), backup/restore (couldn't completely automate this task) and we would try to replicate it, but we are afraid of too much strain on the machine.Or do you just think I should use a DAT tape to restore these databases.I personally want to use the DAT tape, because it is the fastest, easiest and and we already do a DAT backup every night anyways, but my boss wants it to be a completly automated (no human intervention) daily task.Any (literally any) suggestions would be greatly appreciated.<br>Thanks in advance...

 

[Guest_imported]

Schedule a Backup of your computer A databases to a directory on the network, setup this task on computer A. Set this job to execute at midnight, then an hour or two later setup a task on computer B to restore from the network directoy that contains the computer A databases. You may have to space out the times of these jobs depending on how long it takes to backup computer A.

 

[DCSS]

I need to automatically restore.&nbsp;&nbsp;Is it possible to schedule a restore?&nbsp;&nbsp;If so, how?