Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
scelamko
Constraint Violating Yak Guru
309 Posts |
 Posted - 2007-07-10 : 10:52:48
|
| Guys,I have remote database on west coast which is 60gb, I want to sync copy of the same database (which is in east coast) at the end of each day. I do not want to use replication because of remoting issues.On the remote production database we do a transaction log backup every 1hr, is there any way I can copy the logs and restore it on the copy database. Is there any way to automate the restore process with the transaction logs backup.Any suggestions and inputs would help.Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-10 : 11:02:28
|
| You can use log shipping, but target db is not accessible. |
 |
|
|
|
|
|
Synchronization of Databases