We help IT Professionals succeed at work.

Maintaining 2 indentical SQL Server Databases

205 Views
Last Modified: 2012-08-14
My team has 2 web projects taking data from the same SQL server 2000 database.  One project can have read and write right and data is updated from this project while the other just needs the read right from this database.  When many users query data at the same time, the server will choke and times out on certain queries.  The fastest solution probably is to have 2 copy of the same database running at the same time and each project gets data from its own database.  We can accept the fact that the read only project may not have data updated in real time because data is updated from the project that can write data into the database but we would like to keep data to be in sync in real time as close as possible, what may be the suitable solution for this?

Thank you.
Comment
Watch Question

Imran Javed ZiaConsultant Software Engineer - .NET Architect
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Alpesh PatelSolution Architect at TCS (SAFe®Agilist, TOGAF® Foundation, PSM I®, MCP, MCSD)
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Senior Data Architect
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.