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 |
|
NJDave
Starting Member
1 Post |
 Posted - 2011-06-14 : 16:06:33
|
| HelloWe have 2 servers on different networks and we are looking for a way to keep 3 databases on one server updated with the changes made to the 3 databases on the other server.The destination server can be read only.One idea was to use log shipping but security was a concern - its assumed that log shipping would require a network login and could be a security issue - what access does log shipping need and where can I get details so I can assure that log shipping is not a security threat.I am also looking to see what our options are - how else can we do this/ thanks in advanceVERSION INFOCopy from...Production SP Edition10.0.2531.0 SP1 Enterprise Edition (64-bit)Copy to...Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (X64) Sep 16 2010 19:43:16 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2) |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
DB sync options