Home Database Mysql Tutorial SQL Server2005配置同步复制

SQL Server2005配置同步复制

Jun 07, 2016 pm 05:38 PM
Synchronize copy Configuration

因为实际需要,需要对两台SQL Server服务器配置同步复制。记录一下配置过程。 配置环境 两台服务器: 发布服务器,以下简称PS。 订阅服务器,以下简称SS。 两台服务器都是Windows Server 2003,SQL Server是2005企业版64位。 测试数据库为TestRepl 创建Windo

因为实际需要,需要对两台SQL Server服务器配置同步复制。记录一下配置过程。

配置环境

两台服务器:

发布服务器,以下简称PS。

订阅服务器,以下简称SS。

两台服务器都是Windows Server 2003,SQL Server是2005企业版64位。

测试数据库为TestRepl

 

创建Windows用户

在PS和SS上分别创建用户ReplUser-PS和ReplUser-SS,都隶属于Administrator组。

 

创建快照文件共享目录

在PS上创建存放快照文件的物理目录并设置为共享目录,比如:D:\ReplData,右键ReplData文件夹——点击属性——选择共享选项卡——点击权限按钮——弹出分配权限窗口——添加之前创建的专门用于数据同步复制的Windows帐号 RelUser-PS——权限勾选"完全控制"——确定。

  

创建数据库登录名

在PS上登录数据创建一个新的数据库登录名,类型为Windows 身份验证,名称就是之前添加的用户名,不过注意这里需要域名+用户名。可以在添加隶属用户组的时候看到这个全名。

点击用户映射,勾选上测试数据库,角色勾选上db_owner和public。确定即可。

 

创建发布

在PS上的SQL Server2005 Managerment Studio中右击复制——本地发布打开发布向导。接下来就是按步骤一步步来了。

快照路径就是刚设置的共享目录。

选择发布对象。

设置发布计划。注意:发布创建后计划不能修改,,需要提前规划好。

设置安全代里。用户就是之前建立的用户。

点击完成就可以了。

注意:必须以登录默认实例才能进行发布操作:

否则会报如下错误:

 

相互注册数据库引擎

在PS上注册SS,点击SQL Server Management Studio——视图——已注册的服务器——右击“数据库引擎”——新建“服务器注册”,如图填写注册信息,测试保存。

同样的再SS上注册PS。

 

创建订阅

 类似的登录SS上默认实例的SQL Server2005 Managerment Studio中右击复制——本地订阅打开订阅向导一步步设置就可以了。

 第一配置应该看不到PS上发布的订阅,点击,以SQL Server验证方式登入PS上SQL Server的默认实例即可。

分发代理设置,选择默认的就行。

设置订阅数据库。注意:这个数据库必须在订阅的SQL Server上存在。

设置分发代理安全性。以SQL Server身份验证登录。点击完成。

注意:这里填的是分发服务器的用户名和密码。

代理计划根据实际需要制定。注意:订阅创建后计划不能修改,需要提前规划好。

初始化时间选择立即或首次同步时。

另外需要说明的是:

订阅服务和发布服务都依赖于SQL Server的代理。

 

常见错误&注意事项

1、创建订阅,设置安全代理的时候,连接分发服务器选择SQL Server登录名,注意这里填的分发服务器,而不是订阅服务器的。

如果配置出错:右击订阅查看同步状态汇报连接不到分发服务器的错误。

 

2、共享的快照文件夹没有相应的权限。

 

3、快照的文件夹路径应该填的是共享路径而不是绝对路径,上面的配置过程中就配置是错误的:

如果之前配错了,可以右击之前新的发布,点属性:

重新设置快照路径即可。

 

4、新增表或其他对象需要同步需要重新修改发布对象,在发布属性里修改即可。

 

select @@servername

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

One or more items in the folder you synced do not match Outlook error One or more items in the folder you synced do not match Outlook error Mar 18, 2024 am 09:46 AM

When you find that one or more items in your sync folder do not match the error message in Outlook, it may be because you updated or canceled meeting items. In this case, you will see an error message saying that your local version of the data conflicts with the remote copy. This situation usually happens in Outlook desktop application. One or more items in the folder you synced do not match. To resolve the conflict, open the projects and try the operation again. Fix One or more items in synced folders do not match Outlook error In Outlook desktop version, you may encounter issues when local calendar items conflict with the server copy. Fortunately, though, there are some simple ways to help

The working principle and configuration method of GDM in Linux system The working principle and configuration method of GDM in Linux system Mar 01, 2024 pm 06:36 PM

Title: The working principle and configuration method of GDM in Linux systems In Linux operating systems, GDM (GNOMEDisplayManager) is a common display manager used to control graphical user interface (GUI) login and user session management. This article will introduce the working principle and configuration method of GDM, as well as provide specific code examples. 1. Working principle of GDM GDM is the display manager in the GNOME desktop environment. It is responsible for starting the X server and providing the login interface. The user enters

How to copy lyrics from QQ Music How to copy lyrics How to copy lyrics from QQ Music How to copy lyrics Mar 12, 2024 pm 08:22 PM

We users should be able to understand the diversity of some functions when using this platform. We know that the lyrics of some songs are very well written. Sometimes we even listen to it several times and feel that the meaning is very profound. So if we want to understand the meaning of it, we want to copy it directly and use it as copywriting. However, if we want to use it, we still need to You just need to learn how to copy lyrics. I believe that everyone is familiar with these operations, but it is indeed a bit difficult to operate on a mobile phone. So in order to give you a better understanding, today the editor is here to help you. A good explanation of some of the above operating experiences. If you also like it, come and take a look with the editor. Don’t miss it.​

Understand Linux Bashrc: functions, configuration and usage Understand Linux Bashrc: functions, configuration and usage Mar 20, 2024 pm 03:30 PM

Understanding Linux Bashrc: Function, Configuration and Usage In Linux systems, Bashrc (BourneAgainShellruncommands) is a very important configuration file, which contains various commands and settings that are automatically run when the system starts. The Bashrc file is usually located in the user's home directory and is a hidden file. Its function is to customize the Bashshell environment for the user. 1. Bashrc function setting environment

MyBatis Generator configuration parameter interpretation and best practices MyBatis Generator configuration parameter interpretation and best practices Feb 23, 2024 am 09:51 AM

MyBatisGenerator is a code generation tool officially provided by MyBatis, which can help developers quickly generate JavaBeans, Mapper interfaces and XML mapping files that conform to the database table structure. In the process of using MyBatisGenerator for code generation, the setting of configuration parameters is crucial. This article will start from the perspective of configuration parameters and deeply explore the functions of MyBatisGenerator.

How to configure workgroup in win11 system How to configure workgroup in win11 system Feb 22, 2024 pm 09:50 PM

How to configure a workgroup in Win11 A workgroup is a way to connect multiple computers in a local area network, which allows files, printers, and other resources to be shared between computers. In Win11 system, configuring a workgroup is very simple, just follow the steps below. Step 1: Open the "Settings" application. First, click the "Start" button of the Win11 system, and then select the "Settings" application in the pop-up menu. You can also use the shortcut "Win+I" to open "Settings". Step 2: Select "System" In the Settings app, you will see multiple options. Please click the "System" option to enter the system settings page. Step 3: Select "About" In the "System" settings page, you will see multiple sub-options. Please click

PS copy layer shortcut key PS copy layer shortcut key Feb 23, 2024 pm 02:34 PM

In the PS copy layer shortcut keys, we can know that if you want to copy a layer when using PS, you can use the shortcut key [Ctrl+J] for quick copying. This introduction to the shortcut keys for copying layers can tell you the specific operation method. The following is the detailed content, so take a look. PS copy layer shortcut key answer: [Ctrl+J] Specific method: 1. Open the image in PS and select the layer that needs to be copied. 2. Press [Ctrl+J] on the keyboard at the same time to complete the copy of the layer. Other copying methods: 1. After opening the image, press and hold the layer and move the [New Layer] icon downwards. 2. After moving to the icon, let go. 3. The layer copy is completed.

How to configure and install FTPS in Linux system How to configure and install FTPS in Linux system Mar 20, 2024 pm 02:03 PM

Title: How to configure and install FTPS in Linux system, specific code examples are required. In Linux system, FTPS is a secure file transfer protocol. Compared with FTP, FTPS encrypts the transmitted data through TLS/SSL protocol, which improves Security of data transmission. In this article, we will introduce how to configure and install FTPS in a Linux system and provide specific code examples. Step 1: Install vsftpd Open the terminal and enter the following command to install vsftpd: sudo

See all articles