Advertisement

10.10.2008 at 04:03PM PDT, ID: 23805701 | Points: 500
[x]
Attachment Details

Duplicate up to 1000 production databases over a WAN

Asked by nummagumma2 in MS SQL Server

Tags: ,

I am not a DBA and have pretty limited knowledge of SQL.  A client of mine wants to know options for replicating production DB servers in the US with counterparts overseas.   Their goal would be to have the DB servers in both sites be identical.   The DB design is such that there is a single database used for data-entry, and a second one that contains blobs of scanned paper data.   As the second database reaches 10GB a new database is created, so that over time the image databases can be archived off the disk and the data-entry database can remain.   Currently there are 50 data-entry databases with an average of 5 related image databases.  I'd like to have some suggestions on how to architect this solution.Start Free Trial
[+][-]10.10.2008 at 10:49PM PDT, ID: 22692843

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.13.2008 at 03:26PM PDT, ID: 22707120

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.13.2008 at 11:29PM PDT, ID: 22708994

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628