Hello
We 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 all our options are - how else can we do this?
thanks in advance
VERSION INFO
Copy from...
Production SP Edition
10.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)
We 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 all our options are - how else can we do this?
thanks in advance
VERSION INFO
Copy from...
Production SP Edition
10.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)