什么是SQL Server 2008中的镜像，请逐步进行 [英] What is mirroring in SQL server 2008 , please make it in step by step

问题描述

在sql server 2008中镜像如何以简单的方式完成



我尝试过：



在sql server 2008中镜像如何以简单的方式完成

mirroring in sql server 2008 how it is done in simple way

What I have tried:

mirroring in sql server 2008 how it is done in simple way

推荐答案

请至少尝试对自己做一个最小的研究：

数据库镜像（SQL Server） [ ^ ]

Please try at least to do a minimal research of your own:
Database Mirroring (SQL Server)[^]

数据库镜像是在相同或不同计算机上涉及两个SQL Server实例的数据库冗余副本的创建和维护。一个SQL Server实例充当称为主体的主实例，而另一个是称为镜像的镜像实例。可以有第三个SQL Server实例充当见证人（特殊情况）

SQL Server中的数据库镜像概述



强烈建议您在非高峰时段配置数据库镜像，因为配置会影响性能。在配置数据库镜像之前，在主服务器上进行完全备份，事务日志备份，并使用NORECOVERY选项在镜像服务器上恢复它。

看一下这个链接配置SQL Server数据库镜像：一步一步~SQL Server Citation 它将显示您一步一步地在SQL Server中配置数据库镜像的方法。

Database mirroring is the creation and maintenance of redundant copies of a database that involves two SQL Server instances on the same or different machines. One SQL Server instance acts as a primary instance called the principal, while the other is a mirrored instance called the mirror. There can be a third SQL Server instance that acts as a witness (special cases)
An Overview of Database Mirroring In SQL Server

It is highly recommend that you configure database mirroring during off-peak hours because configuration can impact performance. Before configuring database mirroring, take a full backup, transactional log backup on the principal server and restored it on the mirrored server with NORECOVERY option.
Take a look at this link Configure SQL Server Database Mirroring: Step By Step ~ SQL Server Citation it will show you step by step method to method to configure database mirroring in SQL Server.

这篇关于什么是SQL Server 2008中的镜像，请逐步进行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！