Search:
Search questions and share your knowledge with the world here on Questionpoint.

:: Categories ::

Interview Question in Replication

Interview Question :: What is the importance of Replication In Sql Server

ms sql server

Answers to "What is the importance of Replication In Sql Server"

RE: What is the importance of Replication In Sql Server?
In most implementations of database replication, one database server maintains the master copy of the database and additional database servers maintain slave copies of the database Database reads are divided among all of the database servers, which results in a large performance advantage due to load sharing. In addition, database replication can also improve availability because the slave database servers can be configured to take over the master role if the master database server becomes unavailable.
Vote for this answer ::

RE: What is the importance of Replication In Sql Server?
Say if u have 2 instances of SQL server running at diffrent locations and u need to keep the data in both the instance in sync u can use replication
Vote for this answer ::

Notify me whenever an answer is posted for this question Update Alert Setting

Top Tags

- Sharepoint Developer Interview Questions - Java Interview Questions - J2EE Interview Questions - ASP.NET Interview Questions - MOSS 2007 Interview Questions - WPF Interview Questions - Microsoft CRM Interview Questions - Technical Interview Questions for Programmers

Home | Terms Of Service | Contact Us | Site Blog | Investors | Advertise With Us | Disclaimer | Privacy Policy | Questionpoint Widget
© Questionpoint 2008 User-posted content, unless source quoted, is licensed under a Creative Commons Public Domain License