Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sync options

Status
Not open for further replies.

R7Dave

Programmer
Oct 31, 2007
181
US
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)

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top