如何一次更新两台服务器 [英] How to update two servers at once

问题描述

大家好，

我是SQL Server的新手.我想知道如何一次更新两个数据库服务器.
方案是-我在不同位置有两台服务器.我需要更新这两个服务器.服务器A中的更新内容也应该在服务器B中.通过这种方式，当发生连接中断时，用户可以在那里进行工作而不会受到干扰.

我将介绍一些称为日志传送"，镜像"，复制"的内容，但我不知道要实现哪种方法.

请帮帮我.

Hi all,

I am new into SQL Server. I would like to know how to update two database server at once.
Scenario is- I have two servers at different location. I need to update both these servers. What is update in Server A should also be in Server B. By this way when a loss of connection occurs the users can do there work without interruption.

I am going to few stuffs known as Log Shipping, Mirroring, Replications, I don''t know which method to implement.

Please help me out.

推荐答案

我不确定您想做什么，但这听起来是个坏主意.一次更新两个数据库所带来的性能成本，与一次知道服务器多久停机一次所获得的收益相比，却受益匪浅.
考虑到这一点，您经常需要连接到两个服务器以插入或更新数据.如果其中一个失败，则尝试将花费几秒钟，然后失败，这时您的两个数据库将不同步.要获取数据，您可以查看一个数据库，但是，如果正在运行的服务器已关闭，则尝试另一数据库之前仍需花费几秒钟的时间.如果问题是客户端(如果您有稳定的服务器，通常是这样)，那么您可能拥有庞大的数据库，但无论如何您将无法连接！

您需要的是一个备份计划，用于您的主服务器崩溃或有人删除数据库时.您可以在SQL Server中计划备份.您需要多长时间备份一次.
我对此不太熟悉，但是您可以看看此 [

I am not sure what you want to do, but this sounds like a bad idea. The performance cost that comes with updating two databases simultaneously compared to the benefit you have from it when once in who knows how often the server goes out.
Consider this, you constantly need to connect to two servers to insert or update data. If one is down the attempt will take a few seconds and then fail, at which point your two databases will be out of sync. To fetch data you could look at one database, but if the server it is running on is down an attempt will still take several seconds before trying the other database. If the problem is client sided (and if you have a stable server it usually is) then you could have a gazillion databases, but you wouldn''t be able to connect anyhow!

What you need is a backup plan for whenever your main server crashes or someone deletes the database. You can schedule backups in SQL server. How often it needs to backup is up to you.
I am not very familiar with this, but you could take a look at this[^].
It should also be possible to backup only that which has changed since your last backup. This way backups will stack and together you will have your complete database backed up without having the performace hit of a full database backup.
This is all pretty advanced though, and if you are new to SQL server I suggest you Google around, read a book and draw your own conclusions.
Hope that helps :)

这篇关于如何一次更新两台服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！