多个SQL Server [英] Multiple SQL Servers

问题描述

问候......



可以告诉我有关多个SQL Server的信息，以及如何以一个服务器数据的任何变化来管理它们，立即在另一个中完成??



ITS NOT CLUSTERING ...我希望第二台服务器始终处于活动状态，如果发生任何变化，它也会发生在第一台服务器



谢谢大家

解决方案

实施复制。   用于复制和分发数据和 数据库对象来自 one < span class =code-keyword> database   另一个和它还保持一致性。 
 
 
 
请参阅以下链接 更多信息
 
 https：// msdn。 microsoft.com/en-us/library/ms151198.aspx  
 
 http：// www.codeproject.com/Articles/215093/Replication-in-MS-SQL-Server 

Greetings ...

can any one tell me about Multiple SQL Server and how to manage them in a way that any changes in the data of one server, done immediately in the other one??

ITS NOT CLUSTERING ... I want the 2nd server to be active always and also if any changes happened on it will happen on the 1st server

Thank you all

解决方案

Implement Replication. It is a Microsoft technologies for copying and distributing data and database objects from one database to another and It also maintain consistency.



Refer below link for more information 

https://msdn.microsoft.com/en-us/library/ms151198.aspx"

http://www.codeproject.com/Articles/215093/Replication-in-MS-SQL-Server

这篇关于多个SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！